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