CREATE PROCEDURE SP_Fill() 
BEGIN 

DECLARE i INT DEFAULT 0; 



my_loop: LOOP 
SET i = i + 1; 
IF (i > 1000) 
THEN LEAVE my_loop; 
END IF; 

INSERT INTO poradi VALUES(CONCAT('tym - ', i), i, 0); 

END LOOP my_loop; 
END;