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 ;

posted @ 2022-04-15 22:00  认知迭代  阅读(121)  评论(0)    收藏  举报