-- 查看数据库表数据占用空间大小 SELECT TABLE_NAME,DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS,concat(round((DATA_LENGTH+INDEX_LENGTH)/1024/1024,2), 'MB') as data FROM information_schema.tables WHERE TABLE_SCHEMA='app01' ORDER BY DATA_LENGTH+INDEX_LENGTH desc; -- 查看数据库中表的字段个数 SELECT TABLE_NAME,count(TABLE_NAME) from information_schema.COLUMNS where TABLE_SCHEMA='app01' GROUP BY TABLE_NAME; -- 查看数据库各个表的数据行数 SELECT TABLE_NAME,TABLE_ROWS from information_schema.tables where TABLE_SCHEMA='app01';