create procedure p_add()
begin
declare done int default 0;
declare i_id int;
declare i_pr int;
declare i_ci int;
declare i_co int;
declare v_pr varchar(20);
declare v_ci varchar(20);
declare v_co varchar(20);
declare v_add varchar(100);
declare cur1 cursor for select id from new_anhui where length(ADDRESS)=0 ;
declare continue handler for sqlstate '02000' set done=1;
open cur1;
repeat
fetch cur1 into i_id ;
if not done then
set v_add='';
set v_pr='';
set v_ci='';
set v_co='';
select province,city,county into i_pr,i_ci,i_co from new_anhui where id=i_id;
if i_pr>0 then
select name into v_pr from common_area where id=i_pr;
end if;
if i_ci>0 then
select name into v_ci from common_area where id=i_ci;
end if;
if i_co>0 then
select name into v_co from common_area where id=i_co;
end if;
set v_add=concat(v_pr,' ');
set v_add=concat(v_add,' ',v_ci);
set v_add=concat(v_add,' ',v_co);
update new_anhui set address=v_add where id=i_id;
end if;
until done
end repeat;
close cur1;
end;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8797129/viewspace-591375/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8797129/viewspace-591375/