Sql-存储过程-循环结构-while do

DELIMITER $$
CREATE PROCEDURE pWhile()
BEGIN
DECLARE vNum INT;
SET vNum = 0;
WHILE vNum<20 DO
SET vNum= vNum + 1;
END WHILE;
SELECT vNum;
END;$$
DELIMITER ;