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 3645What 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 8921What 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 8073What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner joints , left inner joints ,
HP,
2 8109
Where’s database data actually stored?
What is the difference between heap table and temporary table?
What are the functions in mysql?
What are the advantages of mysql in comparison to oracle?
How do I know if mysql is running on windows?
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
What is a left join mysql?
How can I see all mysql databases?
Is mysql server free?
Explain the difference between mysql and mysql interfaces in php?
What is database clustering in mysql?
What is mysql workbench used for?
What do we use to remove duplicate records while fetching a data in mysql ?
Is mysqli secure?
How can you make a database as your current database?