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 25454

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26083

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

3154

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

TCS,

7 27967

How can we store binary data in mysql?

HP,

2 7448

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

PCS,

1 4121

How do you start and stop MySQL on Windows?

3 7563

How do you start MySQL on Linux?

3 6935

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36083

What?s the default port for MySQL Server?

Yahoo,

4 9683

What does tee command do in MySQL?

1 9046

Can you save your connection settings to a conf file?

1 4657

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

2 7715

Use mysqldump to create a copy of the database?

2 6459

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

TCS,

1 5071

Post New MySQL Questions

Un-Answered Questions { MySQL }

How to shutdown mysql server?

1012

How do you determine the location of mysql data directory?

897

What are the two types of queries?

900

What is the difference between database and table?

962

How do I clear the command in mysql?

903

What is a csv table?

949

how to display nth highest salary from a table in a mysql query? : Mysql dba

1009

Write a query to display even rows in student table using mysql?

857

What is difference between mysql and mysqli?

874

How to get current MySQL version?

1039

What is back end and front end?

862

What is mysql connector used for?

889

What is row?

1038

Explain about reporting services of MYSQL?

1017

What is relational database in mysql?

884

For More Un-Answered { MySQL } Questions Click Here