mysql定时任务
执行mysql语句 DO后是需要执行的sql
每天凌晨1点执行
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 update users set support=0 where support=1;
每隔一分钟执行
CREATE event IF NOT EXISTS temp_event ON SCHEDULE EVERY 1 MINUTE
ON COMPLETION PRESERVE
DO update users set support=0 where support=1;
查看定时任务
SELECT * FROM information_schema.events;
关闭定时任务
DROP event temp_event;
原文地址：https://blog.csdn.net/lisizhe1989/article/details/142876169
免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！