Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
DELIMITER // CREATE EVENT monthly_archive ON SCHEDULE EVERY 1 MONTH STARTS "2024-02-01 01:00:00" DO BEGIN INSERT INTO orders_archive SELECT * FROM orders WHERE created_at < NOW() - INTERVAL 6 MONTH; DELETE FROM orders WHERE created_at < NOW() - INTERVAL 6 MONTH; INSERT INTO event_log (event_name, run_at) VALUES ("monthly_archive", NOW()); END// DELIMITER ;
Result
Open