select COLUMN_NAME from information_schema.COLUMNS where table_name = '表名' and table_schema='数据库名'; 实测有效