MySQL Interview Questions
Questions Answers Views Company eMail

What are the different table present in MYsql?

3 8978

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 8975

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

2176




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

TCS,

7 21846

How can we store binary data in mysql?

HP,

2 4658

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

PCS,

1 1848

How do you start and stop MySQL on Windows?

3 4131

How do you start MySQL on Linux?

3 3696




Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 28245

What?s the default port for MySQL Server?

Yahoo,

4 5584

What does tee command do in MySQL?

1 6873

Can you save your connection settings to a conf file?

1 2754

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

2 5140

Use mysqldump to create a copy of the database?

2 3527

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

TCS,

1 3058


Post New MySQL Questions






Un-Answered Questions { MySQL }

How to create a new view in mysql?

17


How to show all tables with 'mysql'?

15


How to include numeric values in sql statements?

13


In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

23


What is the purpose of using a heap table?

7






What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

24


What are the difference between mongodb and mysql?

8


What do we use to remove duplicate records while fetching a data in mysql ?

10


What is regexp?

8


How to list or view all databases from the mysql server.

1


What are the 'mysql' command line options?

9


change column name and make a unique column so we get no dupes.

4


In which language mysql has been written?

10


How to create table show example

1


What are the difference between now and current_date in mysql?

8