Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Enable event scheduler (my.cnf or session) SET GLOBAL event_scheduler = ON; SHOW VARIABLES LIKE "event_scheduler"; -- List all events SHOW EVENTS; -- List events in a database SHOW EVENTS FROM mydb; -- Simple one-time event CREATE EVENT cleanup_log ON SCHEDULE AT NOW() + INTERVAL 1 HOUR DO DELETE FROM logs WHERE created_at < NOW() - INTERVAL 30 DAY;
Result
Open