mysql存储过程例子

BEGIN
declare v_id int;
declare v_optiona VARCHAR(500);
declare v_optionb VARCHAR(500);
declare v_optionc VARCHAR(500);
declare v_optiond VARCHAR(500);
– DECLARE no int;
DECLARE i int;

declare question_cur cursor  for select questionid,optiona,optionb,optionc,optiond    from t_question;
-- DECLARE CONTINUE HANDLER FOR NOT FOUND SET no=1; #当读到数据的最后一条时,设置no变量为1

– SET no=0; #初始化变量no为0
set i=0;
open question_cur;
while i<=4663 do #判断是不是到了最后一条数据
fetch question_cur INTO v_id,v_optiona,v_optionb,v_optionc,v_optiond;
– select v_id;
insert into topic_option(infoid,optionnum,option) values(v_id,’A’,v_optiona);
insert into topic_option(infoid,optionnum,option) values(v_id,’B’,v_optionb);
insert into topic_option(infoid,optionnum,option) values(v_id,’C’,v_optionc);
insert into topic_option(infoid,optionnum,option) values(v_id,’D’,v_optiond);
set i = i+1;
end while;
CLOSE question_cur;