minalz的博客

MySQL查询最大表列数、行数、占用表空间 1.查询最大表列数 select count(*) from information_schema.COLUMNS where TABLE_SCHEMA='库名' and table_name='表名' select table_name,count(*) from information_schema.COLUMNS where TABLE_SCHEMA='dbname' GROUP BY table_name order by count(*) de