mysql 定时任务

1、set global event_scheduler =1; //开启event_scheduler
4、关闭事件
alter event event_task_payment ON COMPLETION PRESERVE DISABLE;
5、开启事件
alter event event_task_payment ON COMPLETION PRESERVE ENABLE;
6 删除
DROP EVENT event_task_payment;

create event event_task_payment
on schedule every 5 minute
on completion PRESERVE
do call task_payment_byonlinedown();