select TABLE_NAME,count(column_name) from information_schema.COLUMNS where table_schema = "xxxxx" GROUP BY TABLE_NAME
xxxx:数据库的名字
select TABLE_NAME,count(column_name) from information_schema.COLUMNS where table_schema = "xxxxx" GROUP BY TABLE_NAME
xxxx:数据库的名字