Mysql得到某个表的所有字段

使用表别名然后.字段名:

SELECT GROUP_CONCAT('a.',COLUMN_NAME)COLUMN_NAME FROM information_schema.`COLUMNS` WHERE TABLE_NAME='TableName' AND TABLE_SCHEMA='DBName' GROUP BY TABLE_NAME;

不使用别名,直接连接字段名

SELECT GROUP_CONCAT(COLUMN_NAME)COLUMN_NAME FROM information_schema.`COLUMNS` WHERE TABLE_NAME='TableName' AND TABLE_SCHEMA='DBName' GROUP BY TABLE_NAME;