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 11870

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 12181

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

2718

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

TCS,

7 25438

How can we store binary data in mysql?

HP,

2 6276

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

PCS,

1 3087

How do you start and stop MySQL on Windows?

3 5964

How do you start MySQL on Linux?

3 5503

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 32699

What?s the default port for MySQL Server?

Yahoo,

4 7861

What does tee command do in MySQL?

1 8004

Can you save your connection settings to a conf file?

1 3886

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

2 6602

Use mysqldump to create a copy of the database?

2 4998

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

TCS,

1 4314

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is 'mysqlcheck'?

566

In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

2576

What are the 3 main types of search queries?

448

How do I kill a mysql query?

444

What are the benefits of mysql?

470

What is the limit of mysql database?

485

How do I automate a backup in mysql?

467

Does mysql scale well?

497

What is ddl, dml, and dcl?

568

What is the difference between primary key and candidate key?

502

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

554

What do you need to connect php to mysql?

521

What is save point in mysql?

512

What is orm in mysql?

466

What is the purpose of using timestamp data type?

496

For More Un-Answered { MySQL } Questions Click Here