repeat until

SQL/PL

Repeat execution of a list of statements until a condition becomes true

Syntax

repeat_stmt:
          [ label_name:] REPEAT
               statement_list
          UNTIL conditional_expr END REPEAT [ label_name]

Description

The REPEAT statement will repeatedly execute statement_list until the conditional_expr evaluates to true or until a LEAVE (or RETURN in a function) statement is executed. The conditional_expr is evaluated at the end of the loop.

If an ENDREPEAT specifies label_name then an identical opening label_name: must be specified as well.

Example

create procedure cflow(i1 int, i2 int)begin    declare ii, ij int;    if i1 < i2 then        set (ii, ij) = (i1, i1);        w_loop: while ii <= i2 do            set ij = ij * ii;            select i1, i2, ii, ij;            set ii = ii + 1;            if ii > 100 then                leave w_loop;            end if;        end while;    else        set (ii, ij) = (i2, i1);        r_loop: repeat            set ij = ij + ii;            select i1, i2, ii, ij;            set ii = ii + 1;            if ii > 100 then                leave r_loop;            end if;        until ii > i1 end repeat;    end if;end;