mysql定时任务

每天凌晨1点执行特定sql语句

CREATE EVENT IF NOT EXISTS temp_event1   
ON SCHEDULE
EVERY 1 DAY STARTS DATE_ADD(DATE_ADD(CURDATE(), INTERVAL 1 DAY), INTERVAL 1 HOUR)   
ON COMPLETION PRESERVE ENABLE   
DO update `user` set status=0 where status=1;
    
-- 或者
CREATE EVENT IF NOT EXISTS temp_event2
ON SCHEDULE
EVERY '1' DAY STARTS '2018-11-21 01:00:00'
ON COMPLETION PRESERVE
DO update `user` set status=0 where status=1;

每天凌晨1点执行特定存储过程

CREATE EVENT IF NOT EXISTS temp_event3
ON SCHEDULE
EVERY '1' DAY STARTS '2018-11-21 01:00:00'
ON COMPLETION PRESERVE
DO CALL insert_test(1);

每隔一分钟执行

CREATE EVENT IF NOT EXISTS temp_event3
ON SCHEDULE 
EVERY 1 MINUTE
ON COMPLETION PRESERVE
DO CALL insert_test(1);

查看所有定时任务

SELECT * FROM information_schema.events; 

删除定时任务

DROP event temp_event2;