Mysql存储过程中游标的使用以及错误处理

  DECLARE done INT DEFAULT 0;
  DECLARE dept_Id int;
 
  DECLARE cur1 CURSOR FOR select deptId from dept order by deptId;

  --处理错误,当遇到错误的时候将判断条件置为1,如果不处理错误,最后将提示1329-no data zero rows fetched;
  DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;

 

  OPEN cur1;

  REPEAT
    FETCH cur1 INTO dept_Id
    IF NOT done THEN
        --处理事务

    END IF;

    --退出
    UNTIL done END REPEAT;

  CLOSE cur1;