sql查询表的所有字段

select group_concat(COLUMN_NAME) from information_schema.COLUMNS where table_name = '表名' and table_schema = '库名';