declare f cursor
##声明游标
for
SELECT id FROM aoi.pcbtable
where id NOT in(select id from aoi.had_shopfloor_table)
and state > 0 order by id desc limit 10;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
set total = 0;
open f; ##打开游标
REPEAT ##循环获取每一行
fetch f into vID;
if done <> 1 then
call GetShopFloorInfo(vID);
end if;
until done
END REPEAT;
close f;
for
SELECT id FROM aoi.pcbtable
where id NOT in(select id from aoi.had_shopfloor_table)
and state > 0 order by id desc limit 10;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
set total = 0;
open f; ##打开游标
REPEAT ##循环获取每一行
fetch f into vID;
if done <> 1 then
call GetShopFloorInfo(vID);
end if;
until done
END REPEAT;
close f;