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 9101

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 9201

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

2202

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

TCS,

7 21979

How can we store binary data in mysql?

HP,

2 4705

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

PCS,

1 1888

How do you start and stop MySQL on Windows?

3 4189

How do you start MySQL on Linux?

3 3738

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 28449

What?s the default port for MySQL Server?

Yahoo,

4 5641

What does tee command do in MySQL?

1 6913

Can you save your connection settings to a conf file?

1 2789

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

2 5185

Use mysqldump to create a copy of the database?

2 3571

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

TCS,

1 3106

Post New MySQL Questions

Un-Answered Questions { MySQL }

How do I change a procedure in mysql?

Are stored procedures precompiled?

What is mysql database server?

Does facebook still use mysql?

What is bigint in mysql?

Does insert statement lock the table?

What is 'mysqlcheck'?

What is InnoDB?

Where is mysql data stored?

What is mysql community edition?

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...

1886

Why do we use group by and order by function in mysql?

What are ddl statements in mysql?

How can you handle the –secure-file-priv in mysql?

What does schema mean?

For More Un-Answered { MySQL } Questions Click Here