MySQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

MySQL Interview Questions

Questions Answers Views Company eMail

What is difference between group by and order by clause?

964

Explain the difference between mysql and mysql interfaces in php?

1094

What are the purposes of using enum and set data types?

937

Describe mysql transaction properties.

1023

What is a transaction? Describe mysql transaction properties.

1105

Explain the difference between delete and truncate.

992

How can an index be declared in mysql?

948

How can you filter the duplicate data while retrieving records from the table?

899

What are the features of mysql?

989

What is the function of mysqldump?

1074

What is view? How can you create and drop view in mysql?

932

How can you import tables from a sql file into a database by using the mysql client?

1036

How you can create a trigger in mysql?

1002

What is the purpose of using timestamp data type?

921

What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

1024

Post New MySQL Questions

Un-Answered Questions { MySQL }

How to delete a column and add a new column to database

944

What is mysql database extension?

1029

What is pdo in php mysql?

947

How can we change the data type of a column of a table?

1001

Is mysql free software?

968

How to make a copy values from one column to another in mysql?

1036

What is the default port for MySQL Server?

1079

How to present a past time in hours, minutes and seconds?

1051

Is microsoft sql same as mysql?

990

Is mysql good for big data?

941

What is ibdata1?

912

I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

3978

Explain the difference between delete and truncate.

992

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

910

What are the difference between and myisam and innodb?

1022

For More Un-Answered { MySQL } Questions Click Here