场景说明：在某些情况下，我们需要获取到列名如下所示，然后做它用;

一、表结构示例

注：需要获取到每列的字段，然后一行并排显示

 Create Table `lineorder_flat` (
 `LO_ORDERKEY` int NOT NULL COMMENT '',
 `LO_ORDERDATE` date NOT NULL COMMENT '',
 `P_BRAND` varchar NOT NULL COMMENT '',
 `LO_CUSTKEY` int NOT NULL COMMENT '',
 `LO_SUPPLYCOST` int NOT NULL COMMENT '')engine=innodb;

二、预期结果

(1)预期获得列结果一行显示

"LO_ORDERKEY","LO_ORDERDATE","P_BRAND","LO_CUSTKEY","LO_SUPPLYCOST"

(2)预期获得列结果竖排显示

 "LO_ORDERKEY",                
 "LO_ORDERDATE",               
 "P_BRAND",                    
 "LO_CUSTKEY",                 
 "LO_SUPPLYCOST"                

三、实现SQL

## 查询列名称,横排显示
select GROUP_CONCAT('"',COLUMN_NAME ,'"') from information_schema.COLUMNS where table_name = '表名' and table_schema = '库名';
 
##查询列名称，竖排显示
select CONCAT('"',COLUMN_NAME ,'",') from information_schema.COLUMNS where table_name = '表名' and table_schema = '库名';

四、附信息

实现获取字段名、列类型等，且类型按照竖排显示

SELECT
	COLUMN_NAME AS 字段名,
	DATA_TYPE AS 数据类型,
	COLUMN_COMMENT AS 字段注释 
FROM
	INFORMATION_SCHEMA.COLUMNS 
WHERE
TABLE_SCHEMA = 'dms_app_dev';