CREATE DEFINER=`jkt44`@`localhost` PROCEDURE `dupa`()
BEGIN
DECLARE cur INT(11);
DECLARE id_zawodu INT;
DECLARE finished INTEGER DEFAULT 0;
DECLARE salaryOverflow INTEGER DEFAULT 0;
DECLARE curID
CURSOR FOR
SELECT id FROM osoba;
DECLARE CONTINUE HANDLER
FOR NOT FOUND SET finished = 1;
OPEN curID;
main_loop: LOOP
IF finished THEN
LEAVE main_loop;
END IF;
FETCH curID INTO cur;
SELECT cur;
END LOOP;
CLOSE curID;
END