Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
DELIMITER // CREATE EVENT safe_cleanup ON SCHEDULE EVERY 1 HOUR DO BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN INSERT INTO event_errors (event_name, error_time) VALUES ("safe_cleanup", NOW()); END; DELETE FROM sessions WHERE expires_at < NOW(); UPDATE stats SET last_cleanup = NOW() WHERE stat_key = "session_cleanup"; END// DELIMITER ;
Result
Open