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

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

posted @ 2021-05-25 11:27  94cool  阅读(282)  评论(0编辑  收藏  举报