declare v_id int;
declare usrcur cursor for select name form t_app_tbl where enable=1;
declare continue handler for NOT FOUND set done=1;
open usrcur;
usrloop :LOOP
fetch usrcur into usr_name;
if done=1 then
leave usrloop;
end if;
select id into v_id from t_mer_tbl where name = usr_name;
loop循环多次时,当前一次循环v_id有值,下一次循环没有记录时,v_id会
赋值为上次一循环的v_id;为什么会这样,正常不是应该是null吗?