MySQL Automatic execution events

#显示定时任务
SHOW EVENTS;
#查看是否开启定时器
SHOW VARIABLES like ' Event_scheduler ';
#开启定时器 (Admin user required)
SET GLOBAL event_scheduler = on;

#创建事件, 12-31 days a year 00:00:00 execution
The DROP event IF EXISTS "event name";
DELIMITER//
"Event name" of the CREATE event
On SCHEDULE Every 1 year starts ' 2017-12-31 00:00:00 '
Do call "functions, stored procedures, views"
//
DELIMITER;

#启动事件
ALTER event name "on completion PRESERVE ENABLE;

#关闭事件
#ALTER event name "on completion PRESERVE DISABLE;

Date 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}

MySQL Automatic execution events