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 13091

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 13726

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

3024

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

TCS,

7 27100

How can we store binary data in mysql?

HP,

2 7022

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

PCS,

1 3710

How do you start and stop MySQL on Windows?

3 7024

How do you start MySQL on Linux?

3 6405

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 34875

What?s the default port for MySQL Server?

Yahoo,

4 9082

What does tee command do in MySQL?

1 8639

Can you save your connection settings to a conf file?

1 4436

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

2 7380

Use mysqldump to create a copy of the database?

2 5912

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

TCS,

1 4846

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is the difference between the primary and unique key in mysql?

766

Can we store files in mysql?

752

What is action query?

742

How do you name a table?

723

How to return query output in html format?

792

How many tables we can create in mysql database?

779

How to convert character strings to dates?

861

What is mysql database used for?

789

What is database clustering in mysql?

804

How would concatenate strings in mysql?

802

all the queries used in sql

2442

How do I remove a user from mysql?

852

How do I view a mysql database?

755

How do I automate a backup in mysql?

780

How is data stored in mysql?

767

For More Un-Answered { MySQL } Questions Click Here