Cursor em MySQL

Cursor em MySQL.sql

DELIMITER $$

DROP PROCEDURE IF EXISTS teste $$
CREATE PROCEDURE teste()
BEGIN
    DECLARE v_finished INTEGER DEFAULT 0;
	--Declara??o das variaveis
    DECLARE v_email varchar(100) DEFAULT "";
    DECLARE v_fone varchar(100) DEFAULT "";

    -- declare cursor 
    DEClARE cur CURSOR FOR
        select party_name, primary_phone_number from mediador;

    -- declare NOT FOUND handler
    DECLARE CONTINUE HANDLER
        FOR NOT FOUND SET v_finished = 1;
		
    OPEN cur;
    get_cur: LOOP
        FETCH cur INTO v_email, v_fone;
        IF v_finished = 1 THEN
            LEAVE get_cur;
        END IF;

        -- build Execu??o
        insert into nomes(nome) value (v_email);
        insert into tel(tele) value (v_fone);

    END LOOP get_cur;

    CLOSE cur;

END$$

DELIMITER ;

Exemplo de cursor em MySQL