mysql如何查詢表中所有字段的名字

select COLUMN_NAME,column_comment from INFORMATION_SCHEMA.Columns where table_name='表名' and table_schema='數據庫名'