大佬来帮忙看一下这个报错!!!"/>
大佬来帮忙看一下这个报错!!!
大佬来帮忙看一下这个报错!!!
- sql语句
- 报错内容
sql语句
DECLARE idCur cursor for select aid,depid from z_id_card_1;
open idCur;
declare @aid varchar(32) ,@depid varchar(32);
fetch First from idCur into @aid,@depid ;
while @@fetch_status=0
begin
delete from app_investigate where bid !=(SELECT mm.bid from(select bid from app_investigate where aid = @aid and dep_id = @depid limit1 ) );
end
fetch next from idCur into @OrderId ,@userId
end
报错内容
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DECLARE idCur cursor for select aid,depid from z_id_card_1’ at line 1
更多推荐
大佬来帮忙看一下这个报错!!!
发布评论