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 25611

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26315

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

3193

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

TCS,

7 28213

How can we store binary data in mysql?

HP,

2 7549

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

PCS,

1 4193

How do you start and stop MySQL on Windows?

3 7716

How do you start MySQL on Linux?

3 7079

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36378

What?s the default port for MySQL Server?

Yahoo,

4 9833

What does tee command do in MySQL?

1 9128

Can you save your connection settings to a conf file?

1 4719

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

2 7805

Use mysqldump to create a copy of the database?

2 6567

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

TCS,

1 5129

Post New MySQL Questions

Un-Answered Questions { MySQL }

How to use rank function in mysql?

977

What are procedures in mysql?

937

Can varchar be primary key?

916

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

932

How to include character strings in sql statements?

972

How do you connect MySQL database with PHP?

971

How to copy data from one server to another using php?

1038

How can you make a database as your current database?

1036

What is current version of mysql?

968

How set mysql root password?

910

What is unsigned int in mysql?

918

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

1148

What does mysql workbench do?

859

What is the use of concat() in mysql?

985

Can you tell how many values can set the function of mysql to consider?

979

For More Un-Answered { MySQL } Questions Click Here