REPEAT statement
Applies to ❌ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
WHILE's lesser known little sibling is REPEAT, which works the same way as Java's do statement. It is mostly not as useful as WHILE, but can be, occasionally, when a loop must be iterated at least once.
An example:
-- MySQL syntax REPEAT INSERT INTO t (col) VALUES (i); SET i = i + 1; UNTIL i > 10 END REPEAT;
// All dialects
Variable<Integer> i = var("i", INTEGER);
repeat(
insertInto(T).columns(T.COL).values(i),
i.set(i.plus(1))
).until(i.gt(10))
Only few dialects support REPEAT. If it is not supported, we can easily emulate it using labels and the EXIT statement, e.g. in PL/SQL:
-- PL/SQL <<generated_alias_1>> LOOP INSERT INTO t (col) VALUES (i); i := i + 1; EXIT generate_alias_1 WHEN i > 10; END LOOP;
Feedback
Do you have any feedback about this page? We'd love to hear it!