Sql-存储过程-循环结构-repeat
DELIMITER $$
CREATE PROCEDURE prepeat()
BEGIN
DECLARE vNum INT;
SET vNum = 0;
addrepeat:REPEAT
SET vNum= vNum + 1;
UNTIL vNum>20
END REPEAT addrepeat;
SELECT vNum;
END;$$
DELIMITER ;
DELIMITER $$
CREATE PROCEDURE prepeat()
BEGIN
DECLARE vNum INT;
SET vNum = 0;
addrepeat:REPEAT
SET vNum= vNum + 1;
UNTIL vNum>20
END REPEAT addrepeat;
SELECT vNum;
END;$$
DELIMITER ;