mysql定时任务

实现每分钟检查订单是否超时

1、查看所有事件 SHOW EVENTS;

2、查看是否开启定时器SHOW VARIABLES LIKE 'event_scheduler';

开启定时器 0：off 1：on
SET GLOBAL event_scheduler = 1;

3、每分钟更新数据
CREATE EVENT `event_order_timeout` ON SCHEDULE EVERY 1 MINUTE ON COMPLETION NOT PRESERVE ENABLE DO UPDATE ryt_order SET status = 192 WHERE unix_timestamp(now()) - create_time >900 AND status = 100;