SELECT table_schema AS '数据库', table_name AS '表名', table_rows AS '记录数', TRUNCATE(data_length/1024/1024,2) AS '数据容量(MB)', TRUNCATE(index_length/1024/1024,2) AS '索引容量(MB)' FROM information_schema.TABLES ORDER BY data_length DESC, index_length DESC;
查询mysql库表记录数,大小容量
最新推荐文章于 2024-10-27 16:43:31 发布