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 2786What 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 6812What 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 6322What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner joints , left inner joints ,
HP,
2 6823
How do stored procedures work?
What is the default port for mysql and how it can change?
Is mysql a relational database?
What is the default password for mysql?
Is microsoft sql same as mysql?
can you elaborate on blob and text in mysql? : Mysql dba
How do I view mysql logs?
What do we use to remove duplicate records while fetching a data in mysql ?
How do I run mysql without installing?
What is mysql community server?
What language does mysql use?
What is the difference between database and table?
What are the applications required to support mysql?
Can mysql scale horizontally?
How do I restore a mysql database dump file in linux?