mysql游标遍历

begin
DECLARE l_id varchar(32);
DECLARE l_url varchar(1000);
DECLARE done INT DEFAULT 0; -- 标记默认为0

DECLARE t_index CURSOR FOR SELECT t.ID,t.DownloadUrl FROM cdcp.t_operationrelease t limit 1;
-- 写法一：DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1;
-- DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
-- 写法二：DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;

OPEN t_index;
REPEAT
FETCH t_index INTO l_id,l_url;
IF done!=1 THEN
SELECT l_id,l_url;
END IF;
UNTIL DONE END REPEAT;
CLOSE t_index;
        
end