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 6814What 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 6329What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner joints , left inner joints ,
HP,
2 6825
What data type is money?
How to create a table?
Does mysql support nosql?
What is trigger in mysql?
How do I show all mysql databases?
Which is faster innodb or myisam?
What is the difference between a database and a table?
How do I automate a backup in mysql?
How to install mysql?
What do ddl, dml, and dcl stand for?
How do I truncate all tables in mysql?
What is view? How can you create and drop view in mysql?
Is mysql still relevant?
What are all the Common SQL Function?
What is a table schema?