Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE EVENT WIPE_TABLE
- ON SCHEDULE EVERY 1 MINUTE
- STARTS CURRENT_TIMESTAMP
- ENDS CURRENT_TIMESTAMP + INTERVAL 15 DAY
- DO
- DELETE LOW_PRIORITY FROM DATABASENAME.TABLE WHERE DATA < DATE_SUB(NOW(), INTERVAL 90 DAY)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement