MariaDB: SP:LOOP-REPEAT-WHILE


-- Format

[begin_label:] LOOP
    statement_list
END LOOP [end_label]


[begin_label:] REPEAT
    statement_list
UNTIL search_condition
END REPEAT [end_label]


[begin_label:] WHILE search_condition DO
    statement_list
END WHILE [end_label]

-- Example 1

CREATE PROCEDURE dorepeat(p1 INT)
  BEGIN
    SET @x = 0;
    REPEAT SET @x = @x + 1; UNTIL @x > p1 END REPEAT;
  END//

CALL dorepeat(1000)//


-- Example 2

CREATE PROCEDURE dowhile()
BEGIN
  DECLARE v1 INT DEFAULT 5;

  WHILE v1 > 0 DO
    ...
    SET v1 = v1 - 1;
  END WHILE;
END