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 you1 2167
how to take mysql database structure backup6 6961
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 5350
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 5153
What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner joints , left inner joints ,
What is the difference Delete and Drop ?6 5613
how we connect the data base in any programme2 2597
What is check constraint?3 4280
what do you mean by longblob Data type in MySql?3 10339
What is difference b/w composit key n primary key and forigion key?4 5212
Print 3 highest salary9 7987
what programming language which is used for testing and developement in sql?3 2980
what is the advantage of left outer join?2 11926
What is the difference between a Table and a View?3 4599
What are the differences between mysql vs sql server?
What's the latest version of mysql?
How do I edit a table in mysql workbench?
How do I truncate all tables in mysql?
Why does mysql have so many connections?
Can a table have multiple primary keys?
What are the advantages of MySQL when compared with Oracle?
What is unsigned int in mysql?
What port is mysql running on?
How database are managed?
Can we write pl sql mysql?
How do I create a schema in mysql?
What is the difference between BLOB AND TEXT?
What is the difference between truncate and delete?
How do I remove a user from mysql?