mysql事件怎么保存_mysql事件

1) phpmyadmin:

a.开启事件

b.运行sql语句

CREATE EVENT `yl_change_order_status`

ON SCHEDULE EVERY 10 SECOND STARTS ‘2018-02-07 00:00:00‘

ON COMPLETION PRESERVE

DO UPDATE yl_order SET yl_order_status=4 WHERE `yl_order_chat_endtime`

2) navicat

a.查看定时任务是否开启(event_scheduler)

show variables like ‘%sche%‘;

若未开启, set global event_scheduler = ON

b.创建函数

c.创建事件并保存

CALL 函数名()

end....

注:PRESERVE 事件结束保存事件

NOT PRESERVE 事件结束删除事件

参考链接:http://blog.csdn.net/only_lamp/article/details/47659995