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 11519

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 11737

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

2646

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

TCS,

7 24918

How can we store binary data in mysql?

HP,

2 6033

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

PCS,

1 2908

How do you start and stop MySQL on Windows?

3 5665

How do you start MySQL on Linux?

3 5236

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 32084

What?s the default port for MySQL Server?

Yahoo,

4 7486

What does tee command do in MySQL?

1 7849

Can you save your connection settings to a conf file?

1 3737

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

2 6389

Use mysqldump to create a copy of the database?

2 4726

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

TCS,

1 4122

Post New MySQL Questions

Un-Answered Questions { MySQL }

Is mysqli faster than mysql?

392

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

1667

In which year mysql created?

438

What does blob mean in mysql?

410

What are the advantages of mysql in comparison to oracle?

472

Why use mysql procedures?

401

What is ntext?

534

How do I show users in mysql?

429

How does mysql store binary data?

416

How do you rename a table?

430

How does mysql encrypt passwords?

403

How do I edit a trigger in mysql?

415

How can you validate emails using a single query?

384

How do I rename a mysql database?

411

How can I compare two mysql databases?

417

For More Un-Answered { MySQL } Questions Click Here