mysql定时任务

mysql定时任务
查看是否有开启event_scheduler
show variables like "%event_sche%";

打开event_scheduler
set global event_scheduler=1;
关闭event_scheduler
set global event_scheduler=0;

1）创建--每天凌晨1点执行
CREATE EVENT IF NOT EXISTS temp_event
ON SCHEDULE EVERY 1 DAY
ON COMPLETION PRESERVE ENABLE
DO INSERT INTO tuser_days(day) values(NOW());

2）查看
SELECT * FROM information_schema.events;
3)关闭
DROP event temp_event;