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 3502

how to take mysql database structure backup

6 10826

How do you start MySQL on Linux?

Cybernet,

5 7939

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 8712

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 7849

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

HP,

2 7980

What is the difference Delete and Drop ?

6 9055

how we connect the data base in any programme

2 4380

What is check constraint?

3 7389

what do you mean by longblob Data type in MySql?

3 12834

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

4 7827

Print 3 highest salary

9 12445

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

3 5248

what is the advantage of left outer join?

2 14009

What is the difference between a Table and a View?

3 6824

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is cursor in mysql?

888

What is mysql root?

941

How internally data stores in MyISAM and INNODB table types?

2702

How do I kill a mysql query?

895

What is slow query log in mysql?

1098

What is the query to display top 20 rows?

1013

What are date and time data types in mysql?

1015

How do you create a schema?

949

Is mysql easy to learn?

941

What is a definer?

867

Can foreign key have duplicate values?

884

How does mysql clustering work?

912

Is mysql deprecated?

911

What is a simple query?

899

Is mysql relational?

906

For More Un-Answered { MySQL } Questions Click Here