开启定时任务
show variables like '%scheduler%';
set global event_scheduler = 1;
[mysqld]
event_scheduler = 1
创建定时计划的例子,每天定时,自动将日期加1天
CREATE EVENT `every_day_execue`
ON SCHEDULE EVERY 1 DAY STARTS '2020-03-13 09:40:00'
ON COMPLETION PRESERVE
ENABLE
DO
CALL create_phre() ;