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 12732

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 13255

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

2940

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

TCS,

7 26620

How can we store binary data in mysql?

HP,

2 6780

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

PCS,

1 3496

How do you start and stop MySQL on Windows?

3 6684

How do you start MySQL on Linux?

3 6103

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 34256

What?s the default port for MySQL Server?

Yahoo,

4 8701

What does tee command do in MySQL?

1 8408

Can you save your connection settings to a conf file?

1 4242

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

2 7118

Use mysqldump to create a copy of the database?

2 5649

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

TCS,

1 4657

Post New MySQL Questions

Un-Answered Questions { MySQL }

How to show certain selected rows with the value "pcds".

677

Write a query to retrieve a hundred books starting from 20th.

1268

How to use 'mysql' to run sql statements?

751

Explain the different types of mysql joins.

662

How many types of indexes are there in mysql?

680

What is mysql vs sql?

717

How to delete a table.

696

What is mysql ndb?

700

What is the use of mysql workbench?

756

How many rows can be inserted in mysql at a time?

732

How do I delete a table in mysql workbench?

737

How can you calculate the sum of any column of a table?

724

How do you create a schema?

692

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

772

What is mysql sleep process?

721

For More Un-Answered { MySQL } Questions Click Here