select count(*) from information_schema.`COLUMNS` where TABLE_SCHEMA='dbName' -- 数据库名 and TABLE_NAME='tablename'; -- 表名
select count(*) from information_schema.`COLUMNS` where TABLE_SCHEMA='dbName' -- 数据库名 and TABLE_NAME='tablename'; -- 表名
转载于:https://www.cnblogs.com/yangjinwang/p/11213130.html