在navicat 中,不需要用DECLARE 声明变量,,直接使用就可以了,,可是,当我需要声明个游标该如何处理?
DECLARE cursor_s CURSOR FOR
SELECT ID,EpID FROM notice
OPEN cursor_s
FETCH NEXT FROM cursor_s INTO @ID,@EpID
WHILE @@fetch_status = 0
BEGIN
if @ID>10 then
insert into notice1 (@ID,@EpID);
end if;
FETCH NEXT FROM cursor_s INTO @ID,@EpID
END
CLOSE cursor_s
DEALLOCATE cursor_s
DECLARE cursor_s CURSOR FOR
SELECT ID,EpID FROM notice
OPEN cursor_s
FETCH NEXT FROM cursor_s INTO @ID,@EpID
WHILE @@fetch_status = 0
BEGIN
if @ID>10 then
insert into notice1 (@ID,@EpID);
end if;
FETCH NEXT FROM cursor_s INTO @ID,@EpID
END
CLOSE cursor_s
DEALLOCATE cursor_s
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货