Sql-存储过程-循环结构-loop

DELIMITER $$
CREATE PROCEDURE pLoop()
BEGIN
DECLARE vNum INT;
SET vNum = 0;
addLoop:LOOP
IF vNum>20 THEN
LEAVE addLoop;
END IF;
SET vNum= vNum + 1;
END LOOP addloop;
SELECT vNum;
END;$$
DELIMITER ;