Mysql动态生成列

根据其它表数据动态生成列字段

1、声明用户变量

SET @EE='';

 

2、根据表生成动态的字符串列

SELECT @EE:=CONCAT(@EE,'SUM(IF(orgid=\'',ORGID,'\'',',total,0)) AS ',NAME,',') FROM
(SELECT
 DISTINCT fee.ORGID,base.name,base.CREATEDATE
FROM
 HYLM_MANAGE_FEE fee
 INNER JOIN HYLM_BASE_BRANCH base ON fee.orgid = base.SELF_ORGID AND fee.uid = '239' AND base.uid = '239' 
)temp1;

3、预备需要执行的sql字符串

PREPARE stmt2 FROM @EE;

 

4、执行sql字符串

EXECUTE stmt2;