mysql存储过程最后一行报错,另外大神帮我看看我这个执行的效率是不是不高,和游标比怎么样,第一次写存储过程,mysql小白一个
create procedure fiance_import()
begin
declare i int default 0;
declare should varchar(50);
declare pay varchar(50);
declare schid int default 1;
declare operaer varchar(20) default '深渝达驾校';
declare remark varchar(60) default '批量导入';
declare leibie int default 1;
declare stuid int default 0;
declare leiname varchar(20) default '报名费';
declare opera_time datetime;
declare status int default 0;
insert_loop:loop
if i>=33336 then
leave insert_loop;
end if;
set i=i+1;
select yingjiaozongfeiyong+0,yijiaozongfeiyong+0,stuid into should,pay,stuid from yjx_student where id =i;
if should=pay then
set status=2;
end if;
if should >pay then
set status =1;
end if;
set opera_time = now();
insert into yjx_finance_should (`stuid`,`operaer`,`opera_time`,`money`,`yijiao`,`remark`,`leibie`,`leiname`,`schid`,`status`) values (stuid,operaer,opera_time,should,pay,remark,leibie,leiname,schid,status);
insert into yjx_finance_receipt (`stuid`,`operaer`,`opera_time`,`money`,`remark`,`payname`,`schid`) values (stuid,operaer,opera_time,pay,remark,'批量导入',schid);
end;