sql查询表的列名并转为行的形式展示

查询表的列名
select column_name from INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA=‘sfs_server’ and TABLE_NAME=‘t_funds_detail’;

转为行

	select GROUP_CONCAT(column_name) from INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA='sfs-server' and TABLE_NAME='t_funds_detail'

select GROUP_CONCAT(concat(‘a.’,column_name)) from INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA=‘sfs_server’ and TABLE_NAME=‘t_funds_detail’

查询结果
a.id,a.organize_id,a.organize_name,a.order_code,a.product_code,a.product_name,a.busi_code,a.order_center_code,a.payment_slip_code,a.tmall_order_code,a.mybank_order_code,a.order_id,a.unique_code,a.original_busi_code,a.original_order_code,a.data_source_code,a.data_source_name,a.busi_gmt_create,a.busi_type_code,a.busi_type_name,a.order_type_code,a.order_type_name,a.pay_status,a.funds_code,a.funds_name,a.product_type,a.customer_id,a.customer_name,a.commodity_id,a.commodity_code,a.trans_gmt,a.commodity_name,a.commodity_price,a.commodity_number,a.commodity_money,a.cheap_money,a.receive_money,a.tax_money,a.channel_money,a.channel_fee,a.total_money,a.real_money,a.check_status,a.uncheck_money,a.check_time,a.gmt_create,a.create_user_id,a.create_user_name,a.gmt_modified,a.modified_user_id,a.modified_user_name,a.is_deleted,a.remark,a.vehicle_type_code,a.vehicle_type_name

这样就可以快速拿到一张表的列，用来当另一次查询的参数