CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteResult`(IN check_id int(8))
begin
declare done int default 0;
DECLARE l_page_id int(8);
DECLARE l_vul_id int(8);
DECLARE page_cur CURSOR FOR select page_id from page where check_id=check_id;
DECLARE vul_cur CURSOR FOR select vul_id from vul where page_id=l_page_id;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; OPEN page_cur;
page_loop: LOOP
FETCH page_cur into l_page_id;
IF done=1 THEN
LEAVE page_loop;
END IF;
OPEN vul_cur;
vul_loop: LOOP
FETCH vul_cur into l_vul_id;
IF done=1 THEN
LEAVE vul_loop;
END IF;
delete from vul where vul_id=l_vul_id;
delete from checkmap where vul_id=l_vul_id;
delete from reqheadvul where vul_id=l_vul_id;
delete from resheadvul where vul_id=l_vul_id;
END LOOP vul_loop;
CLOSE vul_cur;
delete from page where page_id=l_page_id;
delete from method where page_id=l_page_id;
delete from guavul where page_id=l_page_id;
END LOOP page_loop;
CLOSE page_cur;delete from checkmodel where check_id=check_id;
delete from tree where check_id=check_id;
delete from site where check_id=check_id;
END为什么我进不了第二个游标里面
其他都没问题啊
begin
declare done int default 0;
DECLARE l_page_id int(8);
DECLARE l_vul_id int(8);
DECLARE page_cur CURSOR FOR select page_id from page where check_id=check_id;
DECLARE vul_cur CURSOR FOR select vul_id from vul where page_id=l_page_id;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; OPEN page_cur;
page_loop: LOOP
FETCH page_cur into l_page_id;
IF done=1 THEN
LEAVE page_loop;
END IF;
OPEN vul_cur;
vul_loop: LOOP
FETCH vul_cur into l_vul_id;
IF done=1 THEN
LEAVE vul_loop;
END IF;
delete from vul where vul_id=l_vul_id;
delete from checkmap where vul_id=l_vul_id;
delete from reqheadvul where vul_id=l_vul_id;
delete from resheadvul where vul_id=l_vul_id;
END LOOP vul_loop;
CLOSE vul_cur;
delete from page where page_id=l_page_id;
delete from method where page_id=l_page_id;
delete from guavul where page_id=l_page_id;
END LOOP page_loop;
CLOSE page_cur;delete from checkmodel where check_id=check_id;
delete from tree where check_id=check_id;
delete from site where check_id=check_id;
END为什么我进不了第二个游标里面
其他都没问题啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货