CREATE DEFINER=`jkt44`@`localhost` PROCEDURE `dupa`() BEGIN DECLARE cur INT(11); DECLARE finished INTEGER DEFAULT 0; DECLARE test 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; SET test = test +1; END LOOP; CLOSE curID; SELECT test; END