Create Table: CREATE TABLE `test` ( //测试表
`time` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
//创建事件 3秒钟 插入一次当前时间
create event if not exists test_event on schedule every 3 second do insert into test(time) values (now());
`time` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
//创建事件 3秒钟 插入一次当前时间
create event if not exists test_event on schedule every 3 second do insert into test(time) values (now());
//创建事件 2分钟后开启每一分钟 清空test表,5分钟后停止
create event e_test
on schedule every 1 minute
starts current_timestamp + interval 2 minute
ends current_timestamp + interval 5 minute
do truncate table test