- 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);