ALTER and DROP EVENT
Modify, enable/disable, or remove events as needed. Altering is safer than dropping and recreating.
MySQL
Beginner
3 min read
Altering and Dropping Events
Example
-- 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 Pro Tip
DISABLE keeps the event definition intact — use it for maintenance windows without losing the schedule.