mysql中有group_concat()可以合并多行

select group_concat(CONCAT('if(isnull(',COLUMN_NAME,'),1,0) as ' ,COLUMN_NAME) ) as name ,'aa' as gao from INFORMATION_SCHEMA.COLUMNS
where table_schema='ht_wind' and TABLE_NAME='CBONDBALANCESHEET' 

 

mysql中有group_concat()可以合并多行内容，类似于 sqlserver中for xml path

select AID,ANAME,(
select group_concat(VALUE) from B where B.AID=A.AID
) as AVALUE from A;

 

---表名，字段拼接

select TABLE_NAME,group_concat(CONCAT('if(isnull(',COLUMN_NAME,'),1,0) as ' ,COLUMN_NAME) ) as name from INFORMATION_SCHEMA.COLUMNS
where table_schema='ht_wind' group by TABLE_NAME