begin
declare b int;
declare use_no varchar(10);
declare use_name varchar(400);
declare card_id varchar(400);
declare count int;
declare cur_1 cursor for
select s2.member_id,
s2.realname,
s2.card_id
from bh_member.mb_member s1,bh_member.mb_member_info s2
where s1.id = s2.member_id;
-- DECLARE CONTINUE HANDLER FOR NOT FOUND SET b=1;
SET b = 0;
-- （1） sql 赋值
select count(1) INTO count
from bh_member.mb_member s1,bh_member.mb_member_info s2
where s1.id = s2.member_id;
OPEN cur_1; -- 打开游标
REPEAT
-- 从游标中循环取值
FETCH cur_1 INTO use_no, use_name, card_id;
insert into zh_ceshi(use_no,use_name,card_id) values(use_no, use_name, card_id);
set b = b+1;
UNTIL b = count （不加分号）
END REPEAT;
close cur_1; -- 关闭游标
end
梅花香自古寒来
