1. 打开计划事件开关
SET GLOBAL event_scheduler = ON
2. 查看计划事件是否打开
SELECT @@event_scheduler
3. 设定计划事件
CREATE EVENT IF NOT EXISTS temp_event
ON SCHEDULE EVERY 1 DAY STARTS DATE_ADD(DATE_ADD(CURDATE(), INTERVAL 1 DAY), INTERVAL 1 HOUR)
ON COMPLETION PRESERVE ENABLE
DO [Your SQL here];
4. 查看计划事件列表,有刚才添加的事件,则表示成功!
SELECT * FROM information_schema.events;