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 different table present in MYsql?

3 25638

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26359

How to set the time zone for MySQL to particular country time?

3199

What is the difference between mysql_connect() and mysql_pconnect()?

TCS,

7 28274

How can we store binary data in mysql?

HP,

2 7572

How can you get your MySQL root password, if you lost it?

PCS,

1 4201

How do you start and stop MySQL on Windows?

3 7743

How do you start MySQL on Linux?

3 7097

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36443

What?s the default port for MySQL Server?

Yahoo,

4 9851

What does tee command do in MySQL?

1 9143

Can you save your connection settings to a conf file?

1 4728

How do you change a password for an existing user via mysqladmin?

2 7828

Use mysqldump to create a copy of the database?

2 6596

Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?

TCS,

1 5146

Post New MySQL Questions

Un-Answered Questions { MySQL }

What are slow queries?

905

Why do we use preparedstatement?

916

How to create a test table in your mysql server?

1048

Can you tell the difference between $message and $$message?

970

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

1315

Why do we use the mysql database server?

1050

How to drop an existing view in mysql?

925

how can you test for null values in a database? : Mysql dba

937

Is mysql connect deprecated?

963

what is constraints? Also explain the different types of constraints?

971

What is the maximum no of columns a table can have?

909

How do you shutdown a mysql database?

1048

How do I setup a mysql database?

978

How many entries can mysql handle?

1010

What is sharding in mysql?

972

For More Un-Answered { MySQL } Questions Click Here