drop function getParentList ;
create function getParentList(subId varchar(100),iv_year int)
Returns varchar(1000)begin
declare fid varchar(100) default '';
declare temp varchar(1000) default '';
declare str varchar(1000) default '' ;
declare i_flag int default 0 ;
select count(1) into i_flag from tb_jd_0_f_yxnbdwszylb where dwcode=subId and year= iv_year;
if i_flag>0 then
tt:while subId is not null and iv_year is not null do
select sjdwid,sdwmc into fid,temp from tb_jd_0_f_yxnbdwszylb where dwcode=subId and year= iv_year;
if fid is not null and fid !='' and temp is not null and temp !='' then
if str ='' then
set str= temp;
set subId = fid;
else
if subId != fid then
set str = concat(temp,'',str);
set subId = fid;
else
leave tt;
end if;
end if;
else
set subId = fid;
leave tt;
end if;
end while;
select sjdwid,sdwmc into fid,temp from tb_jd_0_f_yxnbdwszylb where dwcode=subId and year= iv_year ;
if(fid is null or fid = '') then
if str ='' then
set str= temp;
else
set str = concat(temp,'',str);
end if;
end if;
end if;
return str;
end;
mysql 递归查找父类
最新推荐文章于 2023-07-28 14:22:51 发布