Querying rows that are 5 minutes old or more
Querying rows that are older than 5 minutes I recently had a couple separate tasks running on the same database and I wanted to make sure that the second task did not interefere with the other task. To help with this I made sure that the second task...
Querying rows that are older than 5 minutes
I recently had a couple separate tasks running on the same database and I wanted to make sure that the second task did not interefere with the other task.
To help with this I made sure that the second task waited for 5 minutes before grabbing the data.
Here is how you do that in MySQL
SELECT * FROM your_table_name WHERE datecreated <= NOW() - INTERVAL 5 MINUTE;