(mysql.info.gz) ITERATE Statement

Info Catalog

(mysql.info.gz) LEAVE Statement

(mysql.info.gz) Flow Control Constructs

(mysql.info.gz) REPEAT Statement

 
 19.1.9.5 `ITERATE' Statement
 ............................
 
      ITERATE LABEL
 
 `ITERATE' can only appear within `LOOP', `REPEAT', and `WHILE'
 statements. `ITERATE' means "do the loop iteration again."
 
 For 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.gz) LEAVE Statement

(mysql.info.gz) Flow Control Constructs

(mysql.info.gz) REPEAT Statement