获取mysql数据表中的列名

select COLUMN_NAME from information_schema.columns where table_name='table_name'

DESCRIBE table_name

SHOW COLUMNS FROM table_name