MySQL Interview Questions
Questions Answers Views Company eMail

What are the different table present in MYsql?

3 12025

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 12378

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

2746

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

TCS,

7 25631

How can we store binary data in mysql?

HP,

2 6357

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

PCS,

1 3150

How do you start and stop MySQL on Windows?

3 6051

How do you start MySQL on Linux?

3 5592

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 32972

What?s the default port for MySQL Server?

Yahoo,

4 8007

What does tee command do in MySQL?

1 8074

Can you save your connection settings to a conf file?

1 3943

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

2 6695

Use mysqldump to create a copy of the database?

2 5089

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

TCS,

1 4374


Post New MySQL Questions

Un-Answered Questions { MySQL }

What are the advantages of mysql?

565


Can you tell few best practices to be followed for optimization in sql?

532


How to dump a table from a database.

556


How to convert dates to character strings?

566


What is the current root password of mysql?

511






What are features of mysql?

500


What is row level locking in access?

504


What is a string in mysql?

491


Why does mysql have so many connections?

514


What is the difference between timestamp and datetime in mysql?

572


How to delete a column and add a new column to database

531


Explain triggers and stored procedures?

521


How can you increase the performance of mysql select query?

511


What is difference between microsoft sql and mysql?

517


What is a deterministic function?

619