SET GLOBAL event_scheduler = ON;
show variables like 'event_scheduler';
event_scheduler ON
创建event:
CREATE EVENT my_event
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 10 SECOND
DO
UPDATE tbl1SET pic_count = pic_count + 10 WHERE uname = 'aaaa';
查看待执行event:
show events
为空说明已经执行完了。
以上分为三部分:
<1>create event
创建执行活动
<2>on schedule
执行周期以及起始时间等
#schedule:
AT timestamp [+ INTERVAL interval] ... | EVERY interval [STARTS timestamp [+ INTERVAL interval] ...][ENDS timestamp [+ INTERVAL interval] ...]
两种:1.在某个时间点执行:at 某个时间点+某个时间长度:
如上面的:AT CURRENT_TIMESTAMP + INTERVAL 10 SECOND 标识从现在起,10秒后执行;
2.周期性执行:every 每间隔多长时间执行一次,从 某时间点开始,到某个时间点结束。
从