mysql存储过程,open语法报错
代码：CREATEPROCEDUREcurdemo()BEGINDECLAREcur1CURSORFORselect`id`fromxin_inspirationwher...
代码 ：
CREATE PROCEDURE curdemo()
BEGIN
DECLARE cur1 CURSOR FOR select `id` from xin_inspiration where `userid` = 57371
OPEN cur1
read_loop: LOOP
FETCH cur1 INTO a
IF done THEN
LEAVE read_loop
END IF
update xin_inspiration set num = (select count(id) from xin_inspimage where inspid = a) where id = a
END LOOP
CLOSE cur1
END; 展开
CREATE PROCEDURE curdemo()
BEGIN
DECLARE cur1 CURSOR FOR select `id` from xin_inspiration where `userid` = 57371
OPEN cur1
read_loop: LOOP
FETCH cur1 INTO a
IF done THEN
LEAVE read_loop
END IF
update xin_inspiration set num = (select count(id) from xin_inspimage where inspid = a) where id = a
END LOOP
CLOSE cur1
END; 展开
1个回答
展开全部
变量a在哪里有定义呢。
更多追问追答
追问
DECLARE a INT DEFAULT 0
感谢你的回答，a已经定义了，还是报错
追答
游标的select语句变量去掉引号
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
