20th Jun 2008

Delete rows older than x days or x months in MySQL

DELETE FROM `tablename` WHERE `created` < DATE_SUB(NOW(), INTERVAL 5 DAY);

DELETE FROM `tablename` WHERE `created` < DATE_SUB(NOW(), INTERVAL 1 MONTH);

Leave a Reply

Free Anonymous Proxy