定时器要求:
create table chucun(
name varchar(20),
id int
);
create procedure a()
begin
insert into chucun values('杨旭',123456);
end;
create event one
on schedule
every 1 minute
starts date_add(now(),interval 1 minute)
do call a();
show variables like '%event_scheduler%';
SET GLOBAL event_scheduler = OFF;
select * from chucun;