mercredi 6 mai 2015

Execute MySQL statement in the background automatically

I want to delete records from MySQL table which were not updated for longer than 3 minutes. How can I set the timer in the background to manage it without being invoked by events or methods in Java? Is that possible?

DELETE FROM bus WHERE created_at < (NOW() - INTERVAL 5 MINUTE) 

Aucun commentaire:

Enregistrer un commentaire