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 3519

how to take mysql database structure backup

6 10869

How do you start MySQL on Linux?

Cybernet,

5 7968

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 8743

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 7885

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

HP,

2 7992

What is the difference Delete and Drop ?

6 9081

how we connect the data base in any programme

2 4405

What is check constraint?

3 7408

what do you mean by longblob Data type in MySql?

3 12865

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

4 7847

Print 3 highest salary

9 12498

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

3 5273

what is the advantage of left outer join?

2 14021

What is the difference between a Table and a View?

3 6835

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is difference mysql and mysqli?

964

What is cursor in mysql?

897

Can a table have multiple primary keys?

903

What is the use of pdo?

955

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

975

Is mysql same as sql?

898

Is mysql free for commercial use?

927

How to get last inserted id after insert data from a table in mysql?

982

How to insert html code into mysql database using php?

1077

What is the datatype for password in mysql?

982

Why is it called mysql?

914

What is a mysql server?

982

How to enable or disable a row of a table using MySQL in struts?

4103

write a command to view the content of the table

899

What is the full meaning of mysql?

969

For More Un-Answered { MySQL } Questions Click Here