MySQL Interview Questions
Questions Answers Views Company eMail

What is triggers and how it can be used in mysql?

6

what is the difference between between and in operators in mysql?

9

What is the difference between timestamp and datetime in mysql?

9




What are procedures in mysql? Explain

11

Explain the different types of constraints?

9

What are the difference between and myisam and innodb?

8

What is the difference between is null & is not null?

7

How to validate email addresses in mysql?

7




How we can get distinct columns values in mysql?

10

Write a query to display even rows in student table using mysql?

7

How to write optimized query in mysql?

7

How to display odd rows in student table in mysql?

6

What is the difference between myisam dynamic and myisam static in mysql?

15

List some comparisons operators used in mysql?

14

How do I import database through command line?

9


Post New MySQL Questions






Un-Answered Questions { MySQL }

How to control the max size of a heap table?

8


How do you know the version of your mysql server?

11


suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

1151


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

7


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

1






What are string data types?

9


How to show table structure mysql?

9


What is difference between Sql server and MySql database? It may be silly question but i really dont know.

957


Write a command to list all databases in mysql?

9


How to show all tables with 'mysql'?

15


How to validate email addresses in mysql?

7


How can we find out which auto increment was assigned on Last insert?

25


How to use like conditions?

17


How to delete the repeated records from a table?

9


How can you calculate the sum of any column of a table?

9