mysql 定时任务

定时任务
查看event是否开启: show variables like '%sche%';
将事件计划开启: set global event_scheduler=1;
关闭事件任务: alter event e_test ON COMPLETION PRESERVE DISABLE;
开户事件任务: alter event e_test ON COMPLETION PRESERVE ENABLE;

开启event_scheduler，也可以设置为on

set global event_scheduler =1; 

执行定时任务：

CREATE EVENT EVENT_DOHBPB  
ON SCHEDULE EVERY 1 DAY STARTS DATE_ADD(CURDATE(), INTERVAL 1 DAY)
ON COMPLETION PRESERVE ENABLE 
DO CALL do_hbpb();