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.

1127

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

965

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

981

How to update a root password.

1004

How we get sum of column.

1066

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

958

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

999

How to update database permissions/privilages.

1039

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

1025

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

986

How to create table show example

1021

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.

1125

How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

978

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

987

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

998

Post New MySQL Questions

Un-Answered Questions { MySQL }

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

1043

What data type is money?

912

What is memory table?

961

How to rename an existing column in a table?

1118

What is mysql vs sql?

1042

How to drop an existing table in mysql?

1063

What is the datatype for password in mysql?

1034

How can I insert images into a Mysql database?

1114

Is mysql a dbms?

949

How to use mysqldump to create a copy of the database?

1142

How do I start and stop mysql on windows?

1075

How do I get a list of table names in mysql?

988

What do you need to connect php to mysql?

1041

What is ntext?

1143

What is a longblob?

1010

For More Un-Answered { MySQL } Questions Click Here