查询mysql的一张表有多少字段

select count(COLUMN_NAME) from information_schema.`COLUMNS` --

where TABLE_SCHEMA = 'xerp' -- 数据库名xerp

and TABLE_NAME = 'sdb_ome_orders' -- 表名sdb_ome_orders