Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
CREATE EVENT cleanup_expired_sessions ON SCHEDULE EVERY 15 MINUTE DO BEGIN DELETE FROM sessions WHERE last_activity < UNIX_TIMESTAMP() - 7200; -- 2h timeout DELETE FROM password_resets WHERE created_at < NOW() - INTERVAL 1 HOUR; DELETE FROM email_verification_tokens WHERE expires_at < NOW(); DELETE FROM cache WHERE expiration < UNIX_TIMESTAMP(); END;
Result
Open