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;