By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE PROCEDURE RepeatDemo()
BEGIN
DECLARE counter INT DEFAULT 1;
DECLARE result TEXT;
REPEAT
SET result = CONCAT_WS(',', result,counter * 20);
SET counter = counter + 1;
UNTIL counter >= 10
END REPEAT;
-- display result
SELECT result;
END
CALL RepeatDemo;
| result |
|---|
| 20,40,60,80,100,120,140,160,180 |