关于mysql:获取某个表中的所有的字段名一般用于大批量Excel导入数据

SELECT    GROUP_CONCAT( COLUMN_NAME SEPARATOR "    " ) FROM    information_schema.COLUMNS WHERE    TABLE_SCHEMA = 'bioshop_bi_uat'     AND TABLE_NAME = 'dwd_receivable'