select COLUMN_NAME from information_schema.COLUMNS where table_name = 'your_table_name';select COLUMN_NAME from information_schema.COLUMNS where table_name = 'your_table_name' and table_schema = 'your_db_name'; 取出所有字段，用一行显示（中间用英文逗号隔开）

select group_concat(COLUMN_NAME SEPARATOR ',')  from information_schema.COLUMNS where table_name = 'tableName';