mysql获取某个表的所有字段名

select COLUMN_NAME from information_schema.COLUMNS where table_name = 'your_table_name' and table_schema = 'your_db_name';

SHOW COLUMNS FROM `your_table_name`;