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 12241

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 12647

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

2783

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

TCS,

7 25908

How can we store binary data in mysql?

HP,

2 6494

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

PCS,

1 3256

How do you start and stop MySQL on Windows?

3 6216

How do you start MySQL on Linux?

3 5753

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 33379

What?s the default port for MySQL Server?

Yahoo,

4 8256

What does tee command do in MySQL?

1 8174

Can you save your connection settings to a conf file?

1 4025

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

2 6827

Use mysqldump to create a copy of the database?

2 5226

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

TCS,

1 4460

Post New MySQL Questions

Un-Answered Questions { MySQL }

How do I restore a mysql database?

625

How to delete the repeated records from a table?

567

Can we rename database in mysql?

550

using primary can we relate two table, with out foreign key?

2369

What is the purpose of -> in the mysql terminal?

717

What is a mysql server?

590

Is mysql a framework?

562

How do I run mysql from command line?

566

List some mysql advantages and disadvantages?

608

How many rows can mysql handle?

576

Is mysql better than oracle?

560

Is null in mysql?

529

How does php communicate with mysql?

544

Can I copy mysql data directory?

563

How do you create a table in mysql workbench?

548

For More Un-Answered { MySQL } Questions Click Here