SELECT * FROM mysql.event;
SET GLOBAL event_scheduler = 1; -- 开启定时器 0:off 1:on
SHOW VARIABLES LIKE 'event_scheduler';-- 查看是否开启定时器
用set global event_scheduler = on语句开启了事件,但是每次重启电脑。或重启mysql服务后,会发现,事件自动关闭(event_scheduler=OFF),
永久生效需要在my.ini配置文件的[mysqld]部分加上event_scheduler=ON 即可
//测试表
CREATE TABLE `test` (
`time` varchar(20) NOT NULL,
`id` int(10) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`) USING BTREE
)
//创建事件 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