Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
DELIMITER // CREATE EVENT archive_old_orders ON SCHEDULE EVERY 1 DAY STARTS "2024-01-01 02:00:00" DO BEGIN INSERT INTO orders_archive SELECT * FROM orders WHERE status = "completed" AND completed_at < NOW() - INTERVAL 2 YEAR; DELETE FROM orders WHERE status = "completed" AND completed_at < NOW() - INTERVAL 2 YEAR; INSERT INTO event_log VALUES ("archive_old_orders", NOW(), ROW_COUNT()); END// DELIMITER ;
Result
Open