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

MySQL Interview Questions

Questions Answers Views Company eMail

What are the functions of commit and rollback statements?

1016

What is a csv table?

1001

How can you count the total number of records of any table?

919

How can you retrieve a particular number of records from a table?

930

How can you find out the version of the installed mysql?

1 1311

Which mysql function is used to concatenate string?

1 1479

What are the advantages and disadvantages of using mysql?

997

What are the differences between char and varchar data types?

1091

What is a storage engine? What are the differences between innodb and myisam engines?

1061

Explain the different types of mysql joins.

911

What are the differences between innodb and myisam engines?

977

How can you retrieve a portion of any column value by using a select query?

912

What is the default port number of mysql?

943

Which statement is used in a select query for partial matching?

1187

What is the difference between now() and current_date()?

975

Post New MySQL Questions

Un-Answered Questions { MySQL }

What are views in mysql?

920

How to Change a users password from unix shell.

1109

How many rows mysql can handle?

932

How do I start mysql server?

895

How does triggers work in mysql?

953

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

923

I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

1901

What is mysql and mysqli?

921

Is sql similar to mysql?

880

How to load a csv file into a table

1031

How do I view data in mysql workbench?

1012

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

940

What command is used to delete the data from the table without deleting the table structure?

970

What is heap table in mysql?

969

How do I create a stored procedure in mysql?

891

For More Un-Answered { MySQL } Questions Click Here