mysql函数

delimiter $$
drop function if exists fun_get_customerpricegroupconcat$$
create function fun_get_customerpricegroupconcat(cpgepcode varchar(20)) returns varchar(50)
begin
	declare str varchar(500) default '';
	declare fkname varchar(50);
	declare pgname varchar(50);
	
	#声明结束标识
	declare done int default false; 
	
	declare xc_curosr cursor for 
		select fk_name,pg_name from t_ep_customerpricegroupvalue cpv 
		inner join t_di_pricegroup pg on pg.pg_code = cpv.pg_code 
		inner join t_di_feekind fk on cpv.fk_code = fk.fk_code where ep_code = cpgepcode;
	
	#设置终止标志
	declare continue handler for not found set done = true;
	
	#打开游标
	open xc_curosr;
	
	#循环
	fetch xc_curosr into fkname,pgname; 
	while(not done) do  
			set str = concat(str,fkname,':',pgname,';');
			fetch xc_curosr into fkname,pgname; 
	end while; 
	
	
	#关闭游标
	close xc_curosr;

  return str;
end $$
delimiter ;