CREATE DEFINER=`root`@`localhost` PROCEDURE `looping_cursor_54`()
BEGIN
DECLARE fimCursor INTEGER DEFAULT 0;
DECLARE vnome VARCHAR(255);
DECLARE vemail VARCHAR(255);
DECLARE cursor1 CURSOR FOR SELECT nome, email FROM temp_nomes;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET fimCursor = 1;
OPEN cursor1;
WHILE fimCursor = 0 DO
FETCH cursor1 INTO vnome, vemail;
IF fimCursor = 0 THEN
SELECT vnome AS nome, vemail AS email;
END IF;
END WHILE;
CLOSE cursor1;
END;
