(mysql.info) loop-statement

Info Catalog

(mysql.info) case-statement

(mysql.info) flow-control-constructs

(mysql.info) leave-statement

 
 17.2.10.3 `LOOP' Statement
 ..........................
 
      [BEGIN_LABEL:] LOOP
          STATEMENT_LIST
      END LOOP [END_LABEL]
 
 `LOOP' implements a simple loop construct, enabling repeated execution
 of the statement list, which consists of one or more statements. The
 statements within the loop are repeated until the loop is exited;
 usually this is accomplished with a `LEAVE' statement.
 
 A `LOOP' statement can be labeled.  END_LABEL cannot be given unless
 BEGIN_LABEL also is present. If both are present, they must be the same.
 

Info Catalog

(mysql.info) case-statement

(mysql.info) flow-control-constructs

(mysql.info) leave-statement