MySQL Interview Questions
Questions Answers Views Company eMail

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

9

What is the difference between having and where clause in mysql? Explain

7

Explain the difference between primary key and candidate key in mysql?

8




How to control the max size of a heap table?

8

How to display top 10 rows in mysql?

8

Is mysql case-sensitive?

8

How triggers can be used in mysql?

12

What are the advantages of mysql?

7




How to create table with same structure of student table in mysql?

7

Write a query to fetch common records between two tables using mysql?

9

What is the use of concat() in mysql?

8

What are the difference between now and current_date in mysql?

8

How to change the database engine in mysql?

9

How to get a version of mysql?

7

In mysql, what is the default storage engine?

10


Post New MySQL Questions






Un-Answered Questions { MySQL }

How to display nth highest salary from a table in a mysql query?

30


Explain timestamp?

12


How to change a password for an existing user via mysqladmin?

27


What is the difference between heap table and temporary table?

25


How to update a root password.

1






How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.

1


How can you move the master database

982


How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

29


How can you make a database as your current database?

11


List some comparisons operators used in mysql?

14


Why is the basic difference between left join, right join and inner join?

9


How can you find out the version of the installed mysql?

9


How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

2


What is the difference between char and varchar?

8


What storage engines are used in MySQL?

28