mysql event

配置:

[mysqld]
event_scheduler = 1

或者:

set  global event_scheduler=1

创建语句:

CREATE EVENT IF NOT EXISTS event_log
ON SCHEDULE EVERY 100 SECOND
ON COMPLETION PRESERVE enable
DO
begin
// statement
end