CREATE PROCEDURE `prt`()
BEGIN
DECLARE m_end,m_id INT DEFAULT 0;
DECLARE cur CURSOR FOR SELECT id FROM tt01;
DECLARE CONTINUE HANDLER FOR NOT FOUND
BEGIN
SET m_end = 1;# remove warning "No data - zero rows fetched, selected, or processed"
SELECT 1 INTO @t FROM (SELECT 1) AS t;
END;
/*
CREATE TABLE `tt01` ( `id` int(11) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;
*/
OPEN cur;
w1:WHILE 1 DO
FETCH cur INTO m_id;IF m_end =1 THEN
LEAVE w1;
END IF;SELECT m_id;
END WHILE;
CLOSE cur;
END$$
DELIMITER ;