MySQL存储过程-LOOP/BREAK/CONTIUNE

BEGINDECLARE count INT DEFAULT 0;DECLARE js INT DEFAULT 0;aa:LOOPSET js = js+1;IF js = 3 THENITERATE aa; #相当于 CONTINUEEND IF;SET count = count+1;IF js=10 THENLEAVE aa; #相当于BREAK...

bug–0/1

1067人浏览 · 2019-08-11 21:34:00

bug–0/1 · 2019-08-11 21:34:00 发布

BEGIN

DECLARE count INT DEFAULT 0;
DECLARE js INT DEFAULT 0;

aa:LOOP
	SET js = js+1;
	IF js = 3 THEN
		ITERATE aa; #相当于 CONTINUE
	END IF;
	SET count = count+1;
	IF js=10 THEN
		LEAVE aa; #相当于BREAK
	END IF;
END LOOP;
SELECT js,count; #10,9

END

CSDN学习社区

CSDN联合极客时间，共同打造面向开发者的精品内容学习社区，助力成长！

更多推荐