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 9373

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 9503

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

2246

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

TCS,

7 22208

How can we store binary data in mysql?

HP,

2 4816

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

PCS,

1 1985

How do you start and stop MySQL on Windows?

3 4286

How do you start MySQL on Linux?

3 3835

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 28704

What?s the default port for MySQL Server?

Yahoo,

4 5812

What does tee command do in MySQL?

1 6984

Can you save your connection settings to a conf file?

1 2848

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

2 5264

Use mysqldump to create a copy of the database?

2 3650

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

TCS,

1 3207

Post New MySQL Questions

Un-Answered Questions { MySQL }

What do ddl, dml, and dcl stand for?

What is row level locking in mysql?

Why are function needed?

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

How to enter numeric values as hex numbers?

What is mysql in dbms?

What are triggers in mysql?

What are the different types of triggers in mysql?

How to display nth highest salary from a table in a mysql query?

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

103

Can I install mysql on mac?

What is an example of a delimiter?

How to control the max size of a heap table?

What is longblob in mysql?

What is mysql57?

For More Un-Answered { MySQL } Questions Click Here