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;