mysql查詢一張表中有哪些字段？

select COLUMN_NAME from information_schema.COLUMNS where table_name = '表名' and table_schema='資料庫名';
           

實測有效