Mysql stored procedure uses cursors

--complete example

CREATE PROCEDURE Test

BEGIN

--Defining parameters
DECLARE _id INT;

--Defining cursors
DECLARE no_more_products INT DEFAULT 0;
DECLARE Result_test CURSOR for
SELECT num1 from Numtest;

--If the not FOUND cursor
DECLARE CONTINUE HANDLER for not FOUND SET no_more_products = 1;

--Open cursor
OPEN result_test;

--Start cycle
REPEAT

--Read each line
FETCH result_test into _id;

--INSERT statement
INSERT into B (ID) VALUES (_id);

--If the parameter equals 1 jumps out
UNTIL no_more_products = 1

--End Loop
END REPEAT;

--Close cursor
CLOSE result_test;

END

To call a stored procedure:

Call Test