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 3403What 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 8520What 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 7679What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner joints , left inner joints ,
HP,
2 7886
How many TRIGGERS are allowed in MySql table?
How to get a list of columns in an existing table?
change column name and make a unique column so we get no dupes.
What is database clustering in mysql?
What are the different column comparison operators in mysql?
Is mysql an oracle product?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
What is mysql port?
Are stored procedures precompiled?
How do I select a table in mysql?
What language does mysql use?
How do I create a new database in mysql?
How to load data files into tables with 'mysqlimport'?
What is a text delimiter?
How does mysql store binary data?