By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE PROCEDURE `LoopDemoTest`()
BEGIN
DECLARE x INT;
DECLARE str1 text;
SET x = 1;
SET str1 = '';
DISP: LOOP
SET x = x + 2;
IF (x MOD 2) THEN
SET str1 = CONCAT(str1, x, ',');
END IF;
IF (x > 10) THEN
LEAVE DISP;
END IF;
END LOOP DISP;
SELECT str1;
END
CALL LoopDemoTest;
| str1 |
|---|
| 3,5,7,9,11, |