随笔分类 -  Sql-存储过程-循环结构

摘要：DELIMITER $$CREATE PROCEDURE prepeat()BEGIN DECLARE vNum INT; SET vNum = 0; addrepeat:REPEAT SET vNum= vNum + 1;UNTIL vNum>20 END REPEAT addrepeat; SE 阅读全文

摘要：DELIMITER $$CREATE PROCEDURE pLoop()BEGIN DECLARE vNum INT; SET vNum = 0; addLoop:LOOPIF vNum>20 THEN LEAVE addLoop;END IF;SET vNum= vNum + 1; END LOO 阅读全文

摘要：DELIMITER $$CREATE PROCEDURE pWhile()BEGIN DECLARE vNum INT; SET vNum = 0; WHILE vNum<20 DOSET vNum= vNum + 1; END WHILE; SELECT vNum;END;$$DELIMITER 阅读全文