LOOP

Create a simple loop construct. This statement repeatedly executes a block of code until explicitly terminated by a LEAVE statement.

Syntax

[begin_label:] LOOP
    statement_list
END LOOP [end_label]

Description

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 (i.e., ;) 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. end_label cannot be given unlessbegin_label also is present. If both are present, they must be the same.

See Delimiters in the mariadb client for more on delimiter usage in the client.

See Also

• LOOP in Oracle mode

• ITERATE

• LEAVE

• FOR Loops

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}