MySQL Interview Questions
Questions Answers Views Company eMail

what is JOIN? Give example & types of join?

iMedia, Millennium, RAM Software, Satyam,

14 40119

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

Infosys, Sierra Atlantica,

2 12264

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 42601

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 3411

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 4538

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

Systematix,

9 14773

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

Amdocs, MediaSoft,

5 8438

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

1 5764

How to get full name of monthname ?

4 8331

about join

2 4340

about foregine

2 3708

How to find out the second largest element from mysql table

15 25979

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

8 16830

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

8 7745

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

5 8951


Post New MySQL Questions

Un-Answered Questions { MySQL }

How to create a trigger in mysql?

716


Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

741


What is acid in mysql?

651


Is mysql good for large database?

694


What is inner join in mysql?

672


How to store binary data in mysql?

735


Can I install mysql on mac?

746


Explain Access Control Lists.

752


What is localhost in mysql?

779


What is the innodb in mysql?

739


Can you tell few best practices to be followed for optimization in sql?

713


Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

743


How can I remotely connect to mysql database?

694


How do I enable mysqli extension?

698


How to run a sql statement?

777