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

MySQL Interview Questions

Questions Answers Views Company eMail

Differentiate between FLOAT and DOUBLE?

1 1498

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

1117

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

1027

Difference between CHAR and VARCHAR?

1100

How to Change a users password from unix shell.

1122

What are Heap tables?

1 1564

What are the different tables present in MySQL?

1113

What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

1038

What are federated tables?

1185

Give string types available for column?

988

How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

1022

What are the column comparisons operators?

1238

How do you login to MySql using Unix shell?

1173

How to do login in mysql with unix shell.

1109

What are the nonstandard string types?

1286

Post New MySQL Questions

Un-Answered Questions { MySQL }

What does mysql workbench do?

865

What are the advantages/disadvantages of mysql and php?

960

what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

1083

Write a query to display even rows in student table using mysql?

895

What is cast in mysql?

903

What ascii 31?

953

What happens if you no create privilege in a database?

1119

Is mysql easy to learn?

948

Why do we use mysql?

938

Is primary key auto increment?

946

How do you restart mysql?

909

What is memory table?

903

How to delete an existing column in a table?

950

Is mysql open source?

935

What is the command used to create a database using php and mysql?

1147

For More Un-Answered { MySQL } Questions Click Here