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 25822

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26590

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

3254

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

TCS,

7 28551

How can we store binary data in mysql?

HP,

2 7679

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

PCS,

1 4297

How do you start and stop MySQL on Windows?

3 7864

How do you start MySQL on Linux?

3 7241

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36803

What?s the default port for MySQL Server?

Yahoo,

4 10035

What does tee command do in MySQL?

1 9231

Can you save your connection settings to a conf file?

1 4797

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

2 7930

Use mysqldump to create a copy of the database?

2 6687

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

TCS,

1 5227

Post New MySQL Questions

Un-Answered Questions { MySQL }

What are the applications required to support mysql?

1004

How to convert numeric values to character strings?

1127

How do I set user privileges in mysql?

929

How to load data files into tables with 'mysqlimport'?

1048

Explain the difference between primary key and candidate key in mysql?

1016

How to copy data from one server to another using php?

1114

What is the return type of mysqli_query?

923

What is acid in mysql?

910

Which is better mysql or microsoft sql?

980

What is foreign key in mysql?

1095

Can mysql store files?

973

How can I connect mysql database?

944

Is foreign key indexed mysql?

942

What causes mysql too many connections?

1035

Can you tell how to find the number of rows in a resultset using php?

958

For More Un-Answered { MySQL } Questions Click Here