mysql定时器

#show VARIABLES LIKE '%sche%';
#SET global event_scheduler = 1;


/*drop table if exists test;
create table test
(
id int(11) not null auto_increment primary key,
time datetime not null
) engine=innodb default charset=utf8;*/


-- 创建存储过程
/*delimiter ;
drop procedure if exists test_proce ;
create procedure test_proce()
begin
insert into test(time) values(now());
end ;
delimiter ;
show create procedure test_proce;*/


-- 定时器
drop event if exists test_event;
create event test_event
on schedule every 1 second
on completion preserve disable
do call test_proce();


-- 开启
-- alter event test_event on completion preserve enable;
-- 关闭
alter event test_event on completion preserve disable;