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

MySQL Interview Questions

Questions Answers Views Company eMail

How to delete a database from mysql server.

1066

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

910

How to list or view all databases from the mysql server.

921

How to update a root password.

954

How we get sum of column.

1011

How will show all records containing the name "sonia" and the phone number '9876543210'

906

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

921

How to update database permissions/privilages.

973

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

984

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

932

How to create table show example

975

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 to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

933

How to show certain selected rows with the value "pcds".

928

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

944

Post New MySQL Questions

Un-Answered Questions { MySQL }

How to set mysql variable in php?

927

What is a simple query?

904

What is table level locking in mysql?

919

How do I change the max connections in mysql?

894

What are different types of queries?

945

Tell us something about heap tables?

990

What is the use of mysql_close()?

977

How many ways we can retrieve the date in result set of mysql using php?

1119

How do stored procedures work?

1047

Which statement is used to delete a table in MySQL.

910

Does mysql support nosql?

912

How do I create a stored procedure in mysql?

900

List the different types of normalization?

945

What is a blob datatype?

862

How we get sum of column.

1011

For More Un-Answered { MySQL } Questions Click Here