ITERATE#
Synopsis#
ITERATE label
Description#
The 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.
Examples#
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 ITERATE
statement in combination with other statements are available in the SQL
routines examples documentation.