MariaDB: REPEAT Statement
This MariaDB tutorial explains how to use the REPEAT statement (REPEAT UNTIL LOOP) in MariaDB with syntax and examples.
Description
In MariaDB, the REPEAT statement is used when you do not know how many times you want the loop body to execute.
Syntax
The syntax for the REPEAT statement in MariaDB is:
[ label_name: ] REPEAT {...statements...} UNTIL condition END REPEAT [ label_name ];
Parameters or Arguments
- label_name
- Optional. The name associated with the REPEAT loop.
- statements
- The statements of code to execute each pass through the REPEAT loop.
- condition
- The condition that will terminate the REPEAT loop.
Note
- You would use a REPEAT statement when you are unsure of how many times you want the loop body to execute.
- You terminate a REPEAT statement with the UNTIL condition.
Example
Let's look at an example that shows how to use the REPEAT statement in MariaDB:
DELIMITER // CREATE FUNCTION CalcValue ( starting_value INT ) RETURNS INT DETERMINISTIC BEGIN DECLARE total_value INT; SET total_value = 0; label1: REPEAT SET total_value = total_value + starting_value; UNTIL total_value >= 999 END REPEAT label1; RETURN total_value; END; // DELIMITER ;
In this MariaDB LOOP example, the REPEAT statement would repeat the loop until total_value is greater than or equal to 999, at which point the REPEAT loop would be terminated.
Advertisements