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 25451

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26081

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

3153

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

TCS,

7 27958

How can we store binary data in mysql?

HP,

2 7443

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

PCS,

1 4121

How do you start and stop MySQL on Windows?

3 7558

How do you start MySQL on Linux?

3 6931

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36068

What?s the default port for MySQL Server?

Yahoo,

4 9679

What does tee command do in MySQL?

1 9043

Can you save your connection settings to a conf file?

1 4655

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

2 7713

Use mysqldump to create a copy of the database?

2 6455

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

TCS,

1 5069

Post New MySQL Questions

Un-Answered Questions { MySQL }

How to dump a table to a file with 'mysqldump'?

967

What is mysql gpl?

805

What is root password?

859

Can foreign key have duplicate values?

850

How to get last inserted id after insert data from a table in mysql?

935

What is the difference between database and table?

960

How do I clear a mysql database?

901

Is mysql a server?

846

Is mysql a framework?

877

Can we create table in stored procedure?

906

I want to find out all databases starting with ‘test’, I have access to?

1112

How to present a past time in hours, minutes and seconds?

991

Can you tell the difference between $message and $$message?

913

What are the functions of commit and rollback statements?

950

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

964

For More Un-Answered { MySQL } Questions Click Here