MYSQL存储过程问题

mrfish45 2010-10-26 06:09:20
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

为什么我进不了第二个游标里面
其他都没问题啊
...全文
102 2 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
抢街饭 2010-11-11
  • 打赏
  • 举报
回复
圣兽山
toulanggejiguang 2010-11-08
  • 打赏
  • 举报
回复
lalal

20,398

社区成员

发帖
与我相关
我的任务
社区描述
“超文本预处理器”,是在服务器端执行的脚本语言,尤其适用于Web开发并可嵌入HTML中。PHP语法利用了C、Java和Perl,该语言的主要目标是允许web开发人员快速编写动态网页。
phpphpstorm 技术论坛(原bbs)
社区管理员
  • 开源资源社区
  • phpstory
  • xuzuning
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧