MySQL Forums
Forum List  »  Newbie

Re: Automatically delete records from database after a few days
Posted by: Chad Bourque
Date: October 28, 2009 07:29AM

Actually, you would want to schedule that event to run every day, not every 30 days so that each day you are deleting rows older than 30 days.
CREATE EVENT delete_records 
ON SCHEDULE EVERY 1 DAY
...
Chad

Options: ReplyQuote


Subject
Written By
Posted
Re: Automatically delete records from database after a few days
October 28, 2009 07:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.