MySQL cheatsheet: scheduled event

scheduled_event.sql

SET GLOBAL event_scheduler = ON; -- ensures that the MySQL event scheduler is on
    
-- One-time events
CREATE EVENT IF NOT EXISTS my_event
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 12 HOUR -- the event will be run in 12h and then will be deleted
DO
    DELETE * FROM Logs;  -- something random

CREATE EVENT IF NOT EXISTS my_event
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 24 MINUTE -- the event will be run in 24 minutes...
ON COMPLETION PRESERVE -- ... and then won't be deleted
DO
    DELETE * FROM Logs;  -- something random
    

-- Periodic event
CREATE EVENT IF NOT EXISTS my_event
ON SCHEDULE EVERY 1 HOUR -- runs every hour...
STARTS CURRENT_TIMESTAMP -- ... from now ...
ENDS CURRENT_TIMESTAMP + INTERVAL 1 DAY -- ... until tomorrow
DO
    DELETE * FROM Logs;  -- something random