MySQL Interview Questions
Questions Answers Views Company eMail

what is JOIN? Give example & types of join?

iMedia, Millennium, RAM Software, Satyam,

14 39974

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

Infosys, Sierra Atlantica,

2 12218

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 42493

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 3385

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 4498

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

Systematix,

9 14664

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

Amdocs, MediaSoft,

5 8369

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

1 5731

How to get full name of monthname ?

4 8292

about join

2 4307

about foregine

2 3673

How to find out the second largest element from mysql table

15 25842

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

8 16738

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

8 7697

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

5 8896


Post New MySQL Questions

Un-Answered Questions { MySQL }

What is default schema in mysql?

686


How to check server status with 'mysqladmin'?

782


What are the difference between now and current_date in mysql?

960


What is the use of count function in mysql?

761


What is a scalar function?

723


How many rows can mysql hold?

668


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

723


How do you restart mysql?

666


What are the similarities between a function and a procedure?

657


How do I install mysql?

673


How set mysql root password?

690


Why use stored procedures in mysql?

715


How can you make a database as your current database?

695


How can I see mysql database?

671


Write command to import an mysql file?

700