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 25638

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26362

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 28277

How can we store binary data in mysql?

HP,

2 7574

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

PCS,

1 4201

How do you start and stop MySQL on Windows?

3 7746

How do you start MySQL on Linux?

3 7099

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36445

What?s the default port for MySQL Server?

Yahoo,

4 9852

What does tee command do in MySQL?

1 9143

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 7829

Use mysqldump to create a copy of the database?

2 6598

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

TCS,

1 5147

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is innodb mysql?

1084

Is mysql port 3306 tcp or udp?

918

How do I select a database in mysql?

1069

What is username in mysql?

897

How to show table structure mysql?

1008

How do I change global variables in mysql?

903

How to run 'mysql' commands from a batch file?

1057

How do I switch users in mysql?

970

How to use in conditions?

1013

What are mysql queries?

926

What are the steps required to view your mysql database?

1090

Is mysql server free?

929

What is mysql ndb?

890

Can we store videos in mysql database?

939

What is the difference between unix timestamp and mysql timestamp?

1057

For More Un-Answered { MySQL } Questions Click Here