MySQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

MySQL Interview Questions

Questions Answers Views Company eMail

at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 3398

how to take mysql database structure backup

6 10628

How do you start MySQL on Linux?

Cybernet,

5 7776

What is the main different between Null and NOT Null. Difference between Primary and Unique Key. How to Check the database from which application is it possibe.

6 8516

What is Foreign Key? What is the main difference between primary key and Foreign Key ? How Foreign Key can be defined? Is Foreign key is used to join two or more table?

4 7669

What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner joints , left inner joints ,

HP,

2 7885

What is the difference Delete and Drop ?

6 8867

how we connect the data base in any programme

2 4266

What is check constraint?

3 7265

what do you mean by longblob Data type in MySql?

3 12683

What is difference b/w composit key n primary key and forigion key?

4 7688

Print 3 highest salary

9 12193

what programming language which is used for testing and developement in sql?

3 5108

what is the advantage of left outer join?

2 13914

What is the difference between a Table and a View?

3 6713

Post New MySQL Questions

Un-Answered Questions { MySQL }

Why mysql is so popular?

916

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

928

Does uninstalling mysql delete database?

954

How do I start mysql in ubuntu?

961

What is deterministic in mysql?

932

How many ways to get the current time?

923

What is mysql57?

862

Write a query to display current date and time?

886

Can you tell what are various ways to create an index?

819

What are the differences between innodb and myisam engines?

926

Can I copy mysql data directory?

877

What is ndb in mysql?

909

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 ?

2083

How To see all the tables from a database of mysql server.

1010

Is Mysql query is case sensitive?

972

For More Un-Answered { MySQL } Questions Click Here