Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Change schedule ALTER EVENT daily_stats ON SCHEDULE EVERY 1 DAY STARTS "2024-01-01 03:00:00"; -- Disable event (keep definition) ALTER EVENT daily_stats DISABLE; -- Enable again ALTER EVENT daily_stats ENABLE; -- Rename ALTER EVENT daily_stats RENAME TO daily_aggregation; -- Drop permanently DROP EVENT IF EXISTS one_time_cleanup; -- View event definition SHOW CREATE EVENT daily_aggregation\G
Result
Open