Fixed Event Scheduler No data - zero rows fetched, selected, or processed

在windows系统日志里出现Mysql调度错误日志: Fixed Event Scheduler No data - zero rows fetched, selected, or processed

网上找资料说在end loop后增加一行 SELECT ID INTO @Connid FROM information_schema.PROCESSLIST LIMIT 1; 即可

但试了还是不行.

 

经过反复测试, 发现是游标里面的内容Insert ignore into惹的祸, 去掉 ignore  即可