ITERATE label
ITERATE
can appear only within
LOOP
,
REPEAT
,
and
WHILE
statements.
ITERATE
means “do the loop again.”
Example:
CREATE PROCEDURE doiterate(p1 INT) BEGIN label1: LOOP SET p1 = p1 + 1; IF p1 < 10 THEN ITERATE label1; END IF; LEAVE label1; END LOOP label1; SET @x = p1; END
User Comments
Add your own comment.