mysql 存储过程结合游标修改每一行记录的值

create PROCEDURE changestateId(OUT count_num INT)
BEGIN
DECLARE num INT DEFAULT 100;
DECLARE done INT DEFAULT 0;
DECLARE uId INT;
DECLARE cId INT;
DECLARE sId INT;

DECLARE thecur CURSOR FOR
	SELECT userId, id, iStateId from pr_clothing;

DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

SELECT COUNT(*) INTO num from pr_clothing;
SET count_num = num;
SELECT count_num;

set num = 0;
OPEN thecur;
	REPEAT
		FETCH NEXT FROM thecur INTO uId, cId, sId;
		if not done then
		-- SELECT uId;
			SET sId = sId - 9200 + 9200;
			UPDATE pr_clothing set iStateId = sId where userId = uId and id = cId;
			SET num = num + 1;
	  end if;
	UNTIL done END REPEAT;
CLOSE thecur;

SELECT num;
END

-- set @pOUt = 1;
-- CALL changestateId(@pOUt);

-- DROP PROCEDURE changestateId;