SELECT TABLE_NAME,TABLE_ROWS,DATA_LENGTH/1024/1024 "data_LENGTH",CREATE_TIME,TABLE_COLLATION FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = (SELECT D.D FROM (SELECT dataBASE() AS D) AS D) ORDER BY TABLE_ROWS DESC;
mysql 查看当前库每张表的大小
最新推荐文章于 2024-04-15 18:25:20 发布