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 25449

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26080

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

3152

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

TCS,

7 27955

How can we store binary data in mysql?

HP,

2 7442

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 7555

How do you start MySQL on Linux?

3 6930

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36062

What?s the default port for MySQL Server?

Yahoo,

4 9677

What does tee command do in MySQL?

1 9041

Can you save your connection settings to a conf file?

1 4654

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

2 7712

Use mysqldump to create a copy of the database?

2 6453

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

TCS,

1 5068

Post New MySQL Questions

Un-Answered Questions { MySQL }

List data types in mysql? Explain

874

What is the usage of regular expressions in mysql?

861

Can we rename database in mysql?

896

How MySQL Optimizes DISTINCT?

1054

What are string data types?

980

How to create a new view in mysql?

875

What does mysql flush tables do?

911

What does schema mean?

885

What are procedures in mysql? Explain

928

What is mysqli_free_result?

853

What is mysql data directory?

936

How can I see all mysql databases?

839

How to dump a table to a file with 'mysqldump'?

966

Can't connect mysql server on localhost?

1007

How big is a blob mysql?

855

For More Un-Answered { MySQL } Questions Click Here