CREATE EVENT [IF NOT EXISTS] event_name
ON SCHEDULE schedule
[ON COMPLETION [NOT] PRESERVE]
[ENABLE | DISABLE]
[COMMENT 'comment']
DO sql_statement;
schedule:
AT timestamp [+ INTERVAL interval]
| EVERY interval [STARTS timestamp] [ENDS timestamp]
interval:
quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |
WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE |
DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}
alter event `eventname` ON COMPLETION PRESERVE DISABLE;
alter event `eventname` ON COMPLETION PRESERVE enABLE;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11813230/viewspace-620142/ ，如需转载，请注明出处，否则将追究法律责任。
