定时器要求:
定时执行某存储过程,存储过程实现向某表中插入一条数据
每分钟执行一次
show variables like '%event_scheduler%';
set global event_scheduler=on;
create table user01(
user_id int ,
user_name varchar(3)
);
create procedure shijhian()
begin
declare i int default 0;
declare user_id int default 0;
declare user_name VARCHAR(5) ;
while i<1 do
set user_id=i;
set user_name=concat('我',i);
insert into user01() value (user_id,user_name);
set i=i+1;
end while;
end;
create event e_minute
on schedule every 1 minute
do call shijhian();
select * from user01