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 3398What 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 8516What 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 7669What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner joints , left inner joints ,
HP,
2 7885
Why mysql is so popular?
What is the difference between the primary and unique key in mysql?
Does uninstalling mysql delete database?
How do I start mysql in ubuntu?
What is deterministic in mysql?
How many ways to get the current time?
What is mysql57?
Write a query to display current date and time?
Can you tell what are various ways to create an index?
What are the differences between innodb and myisam engines?
Can I copy mysql data directory?
What is ndb in mysql?
suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?
How To see all the tables from a database of mysql server.
Is Mysql query is case sensitive?