mysql 存储过程 与 事件

---将当前时间1分钟前的记录设置成 状态2
create procedure sixpro()
 begin
 declare id int;
 declare stop int default 0;
 declare cur cursor for select uid  from tb_user 
 where signtime < date_add(now(),interval-1 minute);
 declare CONTINUE HANDLER FOR SQLSTATE '02000' SET stop = 1;
 open cur;
 fetch cur into id;
 while stop <> 1 do
 update tb_user set state = 2 where uid = id;
 fetch cur into id;
end while;
 close cur;
 end 

 每5秒调用一次 更新存储事件的事件

create event updateEveryFiveSecond
on schedule every 5 second
on completion preserve
do begin 
call sixpro();
end