CREATE
[DEFINER = { user | CURRENT_USER }]
EVENT
[IF NOT EXISTS]
event_name
ON SCHEDULE schedule
[ON COMPLETION [NOT] PRESERVE]
[ENABLE | DISABLE | DISABLE ON SLAVE]
[COMMENT 'comment']
DO event_body;
schedule:
AT timestamp [+ INTERVAL interval] ...
| EVERY interval
[STARTS timestamp [+ INTERVAL interval] ...]
[ENDS timestamp [+ INTERVAL interval] ...]
interval:
quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |
WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE |
DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}
注释:
Event_name:创建event名字(唯一确认的)
[ON COMPLETION [NOT] PRESERVE] :可选,默认为ON COMPLETION PRESERVE,则执行任务后自动drop该事件, ON COMPLETION NOT PRESERVE则不会drop该事件
[ENABLE | DISABLE | DISABLE ON SLAVE] :可选,表示event状态,enable表示开启,disable表示关闭
Comment:表示注释
event_body:可以为单纯执行语句,也可以是存储过程
在schedule中频率控制:可以是 At timestamp(时间戳)或者every 时间间隔 【从何时开始何时结束】
时间间隔:数字+时间单位