查询Mysql数据库某表下非ID的其他字段

select COLUMN_NAME from information_schema.COLUMNS where table_name = '{tableName}' and table_schema = '{dbName}' and COLUMN_NAME!='id'

原文地址:https://www.cnblogs.com/94cool/p/14807970.html