This MariaDB tutorial explains how to use the REPEAT statement (REPEAT UNTIL LOOP) in MariaDB with syntax and examples.
In MariaDB, the REPEAT statement is used when you do not know how many times you want the loop body to execute.
The syntax for the REPEAT statement in MariaDB is:
[ label_name: ] REPEAT
END REPEAT [ label_name ];
Parameters or Arguments
Optional. The name associated with the REPEAT loop.
The statements of code to execute each pass through the REPEAT loop.
The condition that will terminate the REPEAT loop.
- 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.
Let's look at an example that shows how to use the REPEAT 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;
UNTIL total_value >= 999
END REPEAT label1;
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.