Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

MySQL Interview Questions
Questions Answers Views Company eMail

what is JOIN? Give example & types of join?

iMedia, Millennium, RAM Software, Satyam,

14 34188

what are the optimization techniques for Query optimization performance issues and faster execution of queries

Infosys, Sierra Atlantica,

2 10526

what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?

E2 Solutions, Tesco,

10 38386

in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.

1 2606

if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?

2 3433

how we can use more then one primary key in Single Table

Systematix,

9 11155

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command

Amdocs, MediaSoft,

5 6108

how to find missing numbers between two order numbers; and dates ?

1 4885

How to get full name of monthname ?

4 6703

about join

2 3009

about foregine

2 2402

How to find out the second largest element from mysql table

15 20763

How we can copy one table data into another table whose name same as table but in differ database

8 13836

please give me the answer for this: query which generates the second highest integer in the table?

8 5080

How many tables will create when we create table, what are they?

5 6925


Post New MySQL Questions






Un-Answered Questions { MySQL }

How do I stop a mysql command?

152


How do I tune a mysql query?

156


What is the date format in mysql?

152


What are the disadvantages of stored procedures?

157


What is the difference between char and varchar in mysql?

190






What is the query to display top 20 rows?

205


What is key in mysql?

159


What is mysql server?

154


What is the difference between heap table and temporary table?

218


What is mysql sleep process?

151


What's the difference between mysql and sql server?

158


Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

185


What is procedure in mysql?

155


What is the command used to create a database using php and mysql?

220


What are the features of mysql?

192