Mysql编程-事件调度器

一：语法

create EVENT [IF NOT EXISTS] event_name
on SCHEDULE  schedule
[ON COMPLETION [NOT] PRESERVE]
[ENABLE|DISABLE]
[COMMENT 'comment']
DO
SQL_STATEMENT:

二：几个命令

• 查看调度器的状态

show events \G
show events like 'event_name' \G

• 打开调度器

set global event_scheduler=1;

• 禁用调度器

alter event event_name disable;

• 删除event

drop event event_name