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 12787

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 13326

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

2957

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

TCS,

7 26703

How can we store binary data in mysql?

HP,

2 6821

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

PCS,

1 3536

How do you start and stop MySQL on Windows?

3 6733

How do you start MySQL on Linux?

3 6154

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 34370

What?s the default port for MySQL Server?

Yahoo,

4 8776

What does tee command do in MySQL?

1 8440

Can you save your connection settings to a conf file?

1 4271

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

2 7157

Use mysqldump to create a copy of the database?

2 5690

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

TCS,

1 4683

Post New MySQL Questions

Un-Answered Questions { MySQL }

Can you rename a database in mysql?

740

What is the data type for file in mysql?

737

How do you kill a long running query in mysql?

663

What is dbms in mysql?

752

List some mysql advantages and disadvantages?

733

Is there a way to see the files which are stored?

738

How to create table with same structure of student table in mysql?

715

What is the difference between float and double?

822

Do while loop in mysql procedure?

819

What is view? How can you create and drop view in mysql?

679

How we can create index in mysql?

727

can you tell what are the different set operations available in mysql? : Mysql dba

713

If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?

694

How do I backup mysql database on linux?

696

How do I find users in mysql?

802

For More Un-Answered { MySQL } Questions Click Here