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