ITERATE statement allows processing of blocks in SQL
routines to move processing back to the start of a
context block. Contexts are defined by a
label. If no label
is found, the functions fails with an error message.
FUNCTION count() RETURNS bigint BEGIN DECLARE a int DEFAULT 0; DECLARE b int DEFAULT 0; top: REPEAT SET a = a + 1; IF a <= 3 THEN ITERATE top; END IF; SET b = b + 1; RETURN b; END
Further examples of varying complexity that cover usage of the
statement in combination with other statements are available in the SQL
routines examples documentation.