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 12656

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 13191

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

2918

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

TCS,

7 26517

How can we store binary data in mysql?

HP,

2 6746

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

PCS,

1 3481

How do you start and stop MySQL on Windows?

3 6630

How do you start MySQL on Linux?

3 6052

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 34134

What?s the default port for MySQL Server?

Yahoo,

4 8675

What does tee command do in MySQL?

1 8384

Can you save your connection settings to a conf file?

1 4215

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

2 7087

Use mysqldump to create a copy of the database?

2 5619

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

TCS,

1 4632

Post New MySQL Questions

Un-Answered Questions { MySQL }

How to show table names with 'mysqlshow'?

733

Where is mysql installed on linux?

669

What language does mysql use?

614

How to get a version of mysql?

732

How do I completely remove mysql from windows?

662

How do I change directories in mysql?

647

How can you find out the version of the installed mysql?

933

What is the datatype of image in mysql?

653

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

1999

What is the use of mysql_fetch_array () function in php?

640

Where is the mysql data directory?

680

What is the default port number of mysql?

687

What is int unsigned?

678

What is a string in mysql?

648

suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

1892

For More Un-Answered { MySQL } Questions Click Here