[begin_label:] LOOP statement(s) END LOOP [end_label]
LOOP
implements a simple loop construct,
enabling repeated execution of a particular statement or group
of statements. The statements within the loop are repeated
until the loop is exited, usually this is accomplished with a
LEAVE
statement.
begin_label
and
end_label
must be the same, if both are
specified.
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.