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 25423

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26032

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

3143

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

TCS,

7 27905

How can we store binary data in mysql?

HP,

2 7421

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

PCS,

1 4106

How do you start and stop MySQL on Windows?

3 7535

How do you start MySQL on Linux?

3 6908

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36004

What?s the default port for MySQL Server?

Yahoo,

4 9639

What does tee command do in MySQL?

1 9028

Can you save your connection settings to a conf file?

1 4642

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

2 7685

Use mysqldump to create a copy of the database?

2 6433

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

TCS,

1 5051

Post New MySQL Questions

Un-Answered Questions { MySQL }

How do I know if mysql is running on windows?

971

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

947

What is the difference between char and varchar in mysql?

1005

How to do login in mysql with unix shell.

1029

What is max connections in mysql?

874

Is mysql still popular?

869

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

2050

Define REGEXP?

1034

How do I change a procedure in mysql?

937

How do I completely remove mysql from windows?

912

What are different types of queries?

898

What is a delimiter in mysql?

934

What is row level locking in access?

829

How to analyze tables with 'mysqlcheck'?

1142

What is the date format in mysql?

819

For More Un-Answered { MySQL } Questions Click Here