MySQL 5.4 Reference Manual :: 12 SQL Statement Syntax :: 12.7 MySQL Compound-Statement Syntax :: 12.7.6 Flow Control Constructs :: 12.7.6.3 LOOP Statement
Section Navigation [Toggle]
[begin_label:] LOOPstatement_listEND LOOP [end_label]
LOOP
implements a simple loop construct, enabling repeated execution
of the statement list, which consists of one or more statements,
each terminated by a semicolon (;) statement
delimiter. 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. See Section 12.7.1, “BEGIN ... END
Compound Statement Syntax” for
the rules regarding label use.
User Comments
Add your own comment.