All pages
Powered by GitBook
1 of 1

Loading...

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 statement.

A LOOP statement can be . end_label cannot be given unlessbegin_label also is present. If both are present, they must be the same.

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

See Also

This page is licensed: GPLv2, originally from

LEAVE
labeled
Delimiters
mariadb
ITERATE
LEAVE
FOR Loops
fill_help_tables.sql
LOOP in Oracle mode