This MariaDB tutorial explains how to use the LEAVE statement in MariaDB with syntax and examples.
In MariaDB, the LEAVE statement is used when you want to exit a block of code identified by a label_name, such as a LOOP statement, WHILE statement, or REPEAT statement.
The syntax for the LEAVE statement in MariaDB is:
Parameters or Arguments
The name of the block of code (ie: LOOP, WHILE, REPEAT) to terminate.
- You use the LEAVE statement to terminate a block of code, such as a LOOP statement, WHILE statement, or REPEAT statement that is identified by a label_name.
Let's look at an example that shows how to use the LEAVE statement in MariaDB:
CREATE FUNCTION CalcValue ( starting_value INT )
RETURNS INT DETERMINISTIC
DECLARE total_value INT;
SET total_value = 0;
SET total_value = total_value + starting_value;
IF total_value < 999 THEN
END LOOP label1;
In this LEAVE example, we have created a loop called label1 using the LOOP statement.
The ITERATE statement would cause the loop to repeat while total_value is less than 999. Once total_value is greater than or equal to 999, the LEAVE statement would terminate the LOOP.