select GROUP_CONCAT(COLUMN_name) from information_schema.COLUMNS
where table_schema=‘库名’ and table_name =‘表名’
查询该表的列
最新推荐文章于 2022-04-18 20:08:21 发布
select GROUP_CONCAT(COLUMN_name) from information_schema.COLUMNS
where table_schema=‘库名’ and table_name =‘表名’