Mysql 存储过程 三种循环

                                                Mysql 存储过程 三种循环

DROP PROCEDURE IF EXISTS threeKindsOfCycle;
CREATE PROCEDURE threeKindsOfCycle()
BEGIN
	DECLARE v_sum INT;
	DECLARE v_i   INT;
#LOOP LEAVE END LOOP
	SET v_sum = 0;
	SET v_i   = 1;
	loops : LOOP
		IF v_i <= 100 THEN
			SET v_sum = v_sum + v_i;
			SET v_i = v_i + 1;
		ELSE
			LEAVE loops;
		END IF;
	END LOOP loops;
	SET @loopsum = v_sum;
#REPEAT UNTIL END REPEAT
	SET v_sum = 0;
	SET v_i   = 1;
	REPEAT
		SET v_sum = v_sum + v_i;
		SET v_i = v_i + 1;
	UNTIL v_i >100
	END REPEAT;
	SET @repeatsum = v_sum;
#WHILE DO END WHILE
	SET v_sum = 0;
	SET v_i   = 1;
	WHILE v_i <=100 DO
		SET v_sum = v_sum + v_i;
		SET v_i = v_i + 1;
	END WHILE;
	SET @whilesum = v_sum;
END;

CALL threeKindsOfCycle();
SELECT @loopsum,@repeatsum,@whilesum;