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 3518What 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 8741What 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 7879What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner joints , left inner joints ,
HP,
2 7991
What is heap table in mysql?
How do I view a mysql database?
What is the data type for file in mysql?
How to include character strings in sql statements?
How to determine the location of the data directory?
Why should I use mysql?
How many threads can mysql handle?
How to see the create table statement of an existing table?
What is pdo in mysql?
How does select query work?
How to update a root password.
What is difference between unix timestamp and mysql timestamp?
How do I run mysql from command line?
How do I free up space in mysql?
What is schema in mysql?