(mysql.info) iterate-statement

Info Catalog

(mysql.info) leave-statement

(mysql.info) flow-control-constructs

(mysql.info) repeat-statement

 
 17.2.10.5 `ITERATE' Statement
 .............................
 
      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
 

Info Catalog

(mysql.info) leave-statement

(mysql.info) flow-control-constructs

(mysql.info) repeat-statement