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 25615

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26329

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

3195

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

TCS,

7 28225

How can we store binary data in mysql?

HP,

2 7555

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

PCS,

1 4197

How do you start and stop MySQL on Windows?

3 7725

How do you start MySQL on Linux?

3 7085

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36403

What?s the default port for MySQL Server?

Yahoo,

4 9840

What does tee command do in MySQL?

1 9133

Can you save your connection settings to a conf file?

1 4722

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

2 7809

Use mysqldump to create a copy of the database?

2 6573

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

TCS,

1 5131

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is pdo mysql?

922

What do we use to remove duplicate records while fetching a data in mysql ?

960

What is a left join mysql?

897

What is pdo in php mysql?

938

What is 'mysqladmin' in mysql?

1027

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

1113

What is the use of mysqli_query?

879

How to convert character strings to numeric values?

1118

What is mysql cursor?

886

How do I use mysql?

883

What is database clustering in mysql?

1022

Is mysql easy to learn?

941

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

906

How to control the max size of a heap table?

996

What is prepared statement in mysql?

952

For More Un-Answered { MySQL } Questions Click Here