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

MySQL Interview Questions

Questions Answers Views Company eMail

What is 'mysqld'?

944

How to convert numeric values to character strings?

1062

How to use 'mysql' to run sql statements?

1095

How to install mysql?

1022

How to get a list of indexes of an existing table?

966

How to shutdown mysql server?

1068

How to decrement dates by 1 in mysql?

1008

What happens if null values are involved in expressions?

1034

How to increment dates by 1 in mysql?

1033

What is myisam?

969

What are date and time intervals?

989

How to calculate expressions with sql statements?

1117

How to rename an existing table in mysql?

1033

How to extract a unit value from a date and time?

943

How to get a list of all tables in a database?

1055

Post New MySQL Questions

Un-Answered Questions { MySQL }

What are the different mysql database engines?

1163

What is ndb in mysql?

964

What is the usage of ENUMs in MySQL?

1133

Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

1019

How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.

1064

How can I create a database in mysql?

866

What is 'mysqldump'?

1069

Do while loop in mysql procedure?

1072

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

1006

What is mysqli_free_result?

903

How many columns can be used for creating Index?

1054

In which format data is stored in mysql database?

997

What is mysqli_result?

944

How many queries can mysql handle?

977

How to concatenate two character strings?

1032

For More Un-Answered { MySQL } Questions Click Here