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

MySQL Interview Questions

Questions Answers Views Company eMail

What is the difference between the primary and unique key in mysql?

1040

What is the difference between having and where clause in mysql? Explain

1083

Explain the difference between primary key and candidate key in mysql?

1017

How to control the max size of a heap table?

1051

How to display top 10 rows in mysql?

1093

Is mysql case-sensitive?

954

How triggers can be used in mysql?

1066

What are the advantages of mysql?

1042

How to create table with same structure of student table in mysql?

1008

Write a query to fetch common records between two tables using mysql?

1071

What is the use of concat() in mysql?

1048

What are the difference between now and current_date in mysql?

1 1539

How to change the database engine in mysql?

1076

How to get a version of mysql?

1112

In mysql, what is the default storage engine?

1065

Post New MySQL Questions

Un-Answered Questions { MySQL }

Write a query to count the number of rows of a table in mysql.

995

What is a transaction? Describe mysql transaction properties.

1171

What are the similarities between a function and a procedure?

964

Write a query to stop mysql in unix

1099

How do I restore a mysql database?

1146

List some mysql advantages and disadvantages?

1017

What is the default password for mysql?

949

What is mysql database used for?

1095

What is the size of mysql database?

985

What is text in mysql?

963

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

956

How do I clear the screen in mysql?

1043

What is a deterministic function?

1122

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

1085

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

999

For More Un-Answered { MySQL } Questions Click Here