begin
declare done int DEFAULT 0;declare bankclass varchar(20);
declare bankname varchar(100);
declare bc CURSOR for
select bank.bank_class,bank.bank_name
from bank;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done=1;
open bc;repeat
fetch next from bc into bankclass,bankname;
select bankname;//为何只显示一行?
until done end repeat;
close bc;end为什么只能打印出一条记录?显示一行?其实有很多行数据的!
declare done int DEFAULT 0;declare bankclass varchar(20);
declare bankname varchar(100);
declare bc CURSOR for
select bank.bank_class,bank.bank_name
from bank;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done=1;
open bc;repeat
fetch next from bc into bankclass,bankname;
select bankname;//为何只显示一行?
until done end repeat;
close bc;end为什么只能打印出一条记录?显示一行?其实有很多行数据的!
咖啡豆
等级:
可用分等级:中农
总技术分:0
总技术分排名:336041
结帖率:35.48% 结贴率这么低?!
declare done int DEFAULT 0;
declare bankclass varchar(20);
declare bankname varchar(100);
declare bc CURSOR for
select bank.bank_class,bank.bank_name
from bank;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done=1;
open bc;
repeat
fetch bc into bankclass,bankname; ##//-- chnaged by ACMAIN
select bankname;//为何只显示一行?
until done end repeat;
close bc;
end