mysql 建存储过程 实例

drop PROCEDURE if EXISTS sp_lasq
CREATE PROCEDURE sp_lasq()
    COMMENT '超过5天自动立案'
BEGIN
  declare caseid VARCHAR(50);
  declare case_cursor cursor for  select id from cases where cases.`status`='1' and to_days(now()) - to_days(cases.complainDate)>5;
  open case_cursor;
  case_cursor:loop
  fetch case_cursor into caseid;
     insert into  case_shlc(caseid,userid,option,time,status) values
     (caseid ,'02debc9f-53cd-4bc9-887b-49ffc4e925f2','批量立案',CONCAT(SYSDATE(),'') ,'3') ;
     update cases set cases.`status` ='3' where cases.id = caseid ;
  end loop case_cursor;
  close case_cursor;  
END;