LEAVE

Synopsis

LEAVE label

Description

The LEAVE statement allows processing of blocks in SQL routines to move out of a specified context. Contexts are defined by a label. If no label is found, the functions fails with an error message.

Examples

The following function includes a LOOP labelled top. The conditional IF statement inside the loop can cause the exit from processing the loop when the value for the parameter p is 1 or less. This can be the case if the value is passed in as 1 or less or after a number of iterations through the loop.

FUNCTION my_pow(n int, p int)
RETURNS int
BEGIN
  DECLARE r int DEFAULT n;
  top: LOOP
    IF p <= 1 THEN
      LEAVE top;
    END IF;
    SET r = r * n;
    SET p = p - 1;
  END LOOP;
  RETURN r;
END

Further examples of varying complexity that cover usage of the LEAVE statement in combination with other statements are available in the SQL routines examples documentation.

SQL

Reference

Data Types

Functions

Routines

Synopsis

Description

Examples

See also

​Synopsis

​Description

​Examples

​See also

Synopsis

Description

Examples

See also