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

MySQL Interview Questions

Questions Answers Views Company eMail

How can we get the number of rows affected by query?

1064

What is ISAM?

1112

How can you see all indexes defined for a table?

1117

Define REGEXP?

1105

What are all the Common SQL Function?

1130

How to returns the columns and column information pertaining to the designated table.

1022

What is the difference between BLOB AND TEXT?

1150

How MySQL Optimizes DISTINCT?

1109

How can we find out which auto increment was assigned on Last insert?

1098

How to Set a root password if there is on root password.

1093

What is the difference between MyISAM Static and MyISAM Dynamic?

1046

What is the difference between the LIKE and REGEXP operators?

1035

What storage engines are used in MySQL?

1051

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

1006

Where MyISAM table will be stored and also give their formats of storage?

1064

Post New MySQL Questions

Un-Answered Questions { MySQL }

How to create a new view in mysql?

926

How do I change directories in mysql?

910

Where is the mysql database stored?

910

Which is faster innodb or myisam?

1047

What is cast in mysql?

903

What is the datatype of image in mysql?

919

What tools available for managing mysql server?

1025

What is the latest version of php and mysql?

1214

How many TRIGGERS are allowed in MySql table?

1082

What is a trigger? How you can create a trigger in mysql?

899

Does mysql support nosql?

912

How do I grant privileges to a user in mysql phpmyadmin?

954

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

896

change column name and make a unique column so we get no dupes.

984

How to enter microseconds in sql statements?

982

For More Un-Answered { MySQL } Questions Click Here