Mysql创建定时事件,定时器

1#查看Mysql的定时器是否开启
2show variables like 'event_scheduler';
3#开启Mysql定时器
4SET GLOBAL event_scheduler = 1;
5#关闭Mysql定时器
6SET GLOBAL event_scheduler = 0;
7
8#开启Mysql的定时器后，下面的定时事件才能正常执行
9
10#创建一个定时事件，每5秒执行一次过程update_order_tripstatus()
11CREATE EVENT
12IF NOT EXISTS event_updateorder_tripstatus ON SCHEDULE EVERY 5 SECOND ON COMPLETION PRESERVE DO
13call update_order_tripstatus()
14
15#开启一个定时事件
16ALTER EVENT event_updateorder_tripstatus ON  COMPLETION PRESERVE ENABLE; 
17
18#停止一个定时事件
19ALTER EVENT event_updateorder_tripstatus ON  COMPLETION PRESERVE DISABLE;