totn MariaDB

MariaDB: ITERATE Statement

This MariaDB tutorial explains how to use the ITERATE statement in MariaDB with syntax and examples.

Description

In MariaDB, the ITERATE statement is used when you are want a loop body to execute again. It is used within the LOOP statement, WHILE statement, and REPEAT statement.

Syntax

The syntax for the ITERATE statement in MariaDB is:

ITERATE label_name;

Parameters or Arguments

label_name
The name of the loop to repeat.

Note

  • You use the ITERATE statement to execute the loop again.

Example

Let's look at an example that shows how to use the ITERATE statement in MariaDB:

DELIMITER //

CREATE FUNCTION CalcValue ( starting_value INT )
RETURNS INT DETERMINISTIC

BEGIN

   DECLARE total_value INT;

   SET total_value = 0;

   label1: LOOP
     SET total_value = total_value + starting_value;
     IF total_value < 450 THEN
       ITERATE label1;
     END IF;
     LEAVE label1;
   END LOOP label1;

   RETURN total_value;

END; //

DELIMITER ;

In this ITERATE 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 450. Once total_value is greater than or equal to 450, the LEAVE statement would terminate the LOOP.

Share on: