34,594
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE sp_xxx()
BEGIN
DECLARE _done INT DEFAULT 0;
DECLARE _cur1 CURSOR FOR SELECT xx FROM table;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET _done = 1;
OPEN _cur1;
REPEAT
FETCH _cur1 INTO _xx1,_xx2;
IF NOT _done THEN
--循环部分
--call sp();
END IF;
UNTIL _done END REPEAT;
CLOSE _cur1;
END;