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 25799

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26539

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

3250

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

TCS,

7 28505

How can we store binary data in mysql?

HP,

2 7668

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

PCS,

1 4285

How do you start and stop MySQL on Windows?

3 7851

How do you start MySQL on Linux?

3 7209

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36748

What?s the default port for MySQL Server?

Yahoo,

4 10009

What does tee command do in MySQL?

1 9220

Can you save your connection settings to a conf file?

1 4792

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

2 7920

Use mysqldump to create a copy of the database?

2 6666

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

TCS,

1 5215

Post New MySQL Questions

Un-Answered Questions { MySQL }

What port is mysql running on?

979

Does mysql use sql?

941

What are the difference between now and current_date in mysql?

1519

Create table employee (eno int(2),ename varchar(10)) ?

1050

How can you take the backup and restore a mysql database using php?

1005

Is mysql a framework?

979

Write a query to fetch duplicate records from a table using mysql?

983

What is data in mysql?

939

What is orm in mysql?

948

Can we join 3 tables in mysql?

1012

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2161

Explain the storage engines in mysql?

1051

What is a mysql model?

1001

What is clob in mysql

1005

What is striped backup

2282

For More Un-Answered { MySQL } Questions Click Here