numere_pare.sql

DELIMITER |
DROP PROCEDURE IF EXISTS lefti.numerePare |
CREATE PROCEDURE lefti.numerePare(IN maxim INT)
BEGIN
	DECLARE x INT;
	DECLARE str VARCHAR(255);
	SET x = 1;
	SET str = '';
	loop1: LOOP
		IF x > maxim THEN LEAVE loop1;
		END IF;
		SET x = x + 1;
		IF x mod 2 != 0 THEN ITERATE loop1;
		ELSE SET str = CONCAT(str, x, ', ');
		END IF;
	END LOOP;
	SELECT str;
END |
DELIMITER ;