Mysql的事件调度器

CREATE event myevent
on SCHEDULE AT `CURRENT_TIMESTAMP`()+INTERVAL 1 HOUR
DO
UPDATE myschema.mytable set mycol = mycol+1;

 create table test(id1 varchar(10),create_time datetime);

create EVENT test_event_1
on SCHEDULE
EVERY 5 SECOND
DO
INSERT INTO test4.test(id1,create_time)
VALUES('test',now());

show events \G

show variables like '%scheduler%';

 set global event_scheduler = 1;

CREATE EVENT truc_test
on SCHEDULE EVERY 1 MINUTE
DO TRUNCATE TABLE test;

--禁用event
alter EVENT test_event_1 DISABLE;

--删除event
DROP test_event_1 ;