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 25644

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26371

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

3199

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

TCS,

7 28289

How can we store binary data in mysql?

HP,

2 7578

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

PCS,

1 4202

How do you start and stop MySQL on Windows?

3 7748

How do you start MySQL on Linux?

3 7105

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36453

What?s the default port for MySQL Server?

Yahoo,

4 9855

What does tee command do in MySQL?

1 9145

Can you save your connection settings to a conf file?

1 4728

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

2 7832

Use mysqldump to create a copy of the database?

2 6602

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

TCS,

1 5150

Post New MySQL Questions

Un-Answered Questions { MySQL }

How do I select a database in mysql?

1070

What is the current root password of mysql?

920

What is information_schema in mysql?

992

How many triggers are possible in mysql?

968

In which format data is stored in mysql database?

997

How to validate email addresses in mysql?

1125

What is mysql server used for?

958

What data structure does mysql use?

1016

How to load a csv file into a table

1036

What do you mean by % and _ in the LIKE statement?

985

Explain about reporting services of MYSQL?

1071

Can't connect mysql server on localhost?

1069

How to include character strings in sql statements?

986

What is truncate in mysql?

953

What is RMS Migrations

2395

For More Un-Answered { MySQL } Questions Click Here