Mysql存储过程查询结果插入另一张表并定时启动

//创建存储过程

drop procedure if exists sumindex;

craete procedure sumindex()

begin

　　declare description varchar(20);

　　declare done int default 0;

　　declare cur1 cursor for select count(df.syscode) from d_file df left join d_efile de on df.syscode = de.psyscode;

　　open cur1;

　　fetch cur1 into description;

　　while done<>1

　　do

　　　　insert into s_sumindex(sumfiletype,createtime) values(Description,now());

　　　　fetch cur1 into description;

　　　　end while;

　　　　close cur1;

end;

//设置定时执行

create event if not exists d_sumindex on schedule every 600 second on completion preserve do call sumindex();

//查看event是否开启

show variables like '%sche%';

关闭事件任务
SET GLOBAL event_scheduler = OFF;
alter event e_test ON COMPLETION PRESERVE DISABLE;

开启事件任务
SET GLOBAL event_scheduler = ON;
alter event e_test ON COMPLETION PRESERVE ENABLE;