This MariaDB tutorial explains how to use the LOOP statement in MariaDB with syntax and examples.
In MariaDB, the LOOP statement is used when you are not sure how many times you want the loop body to execute and you want the loop body to execute at least once.
The syntax for the LOOP statement in MariaDB is:
[ label_name: ] LOOP
END LOOP [ label_name ];
Parameters or Arguments
Optional. The name associated with the loop. You use the label_name when executing an ITERATE statement or LEAVE statement.
The statements of code to execute each pass through the loop.
- You would use a LOOP statement when you are unsure of how many times you want the loop body to execute.
- You can terminate a LOOP statement with either a LEAVE statement or a RETURN statement.
Let's look at an example that shows how to use the LOOP 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 < 850 THEN
END LOOP label1;
In this MariaDB LOOP example, the ITERATE statement would cause the loop to repeat while the total_value is less than 850. Once the total_value is greater than or equal to 850, the LEAVE statement would terminate the LOOP.