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 25447

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26073

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

3151

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

TCS,

7 27945

How can we store binary data in mysql?

HP,

2 7440

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

PCS,

1 4120

How do you start and stop MySQL on Windows?

3 7554

How do you start MySQL on Linux?

3 6925

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36055

What?s the default port for MySQL Server?

Yahoo,

4 9668

What does tee command do in MySQL?

1 9038

Can you save your connection settings to a conf file?

1 4650

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

2 7709

Use mysqldump to create a copy of the database?

2 6452

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

TCS,

1 5066

Post New MySQL Questions

Un-Answered Questions { MySQL }

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

960

How do you say mysql?

828

Is mysql better than oracle?

880

Explain the difference between delete and truncate.

940

What is unique key in mysql?

929

What is the use of i-am-a-dummy flag in mysql?

956

How can you make a database as your current database?

965

How do I find users in mysql?

1031

What is delimiter in mysql trigger?

900

Is mysql good for big data?

891

What is max_used_connections in mysql?

901

How to get a list of indexes of an existing table?

916

What is mysql good for?

845

Where’s database data actually stored? Is there a way to see the files which are stored?

933

What does mysql workbench do?

820

For More Un-Answered { MySQL } Questions Click Here