定时任务
查看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();