随笔分类 -  MySQL

[MySQL]查询所有表数据量
摘要：1. 所有表 mysql> SELECT TABLE_NAME,TABLE_ROWS FROM information_schema.`TABLES` WHERE TABLE_SCHEMA = (SELECT database()) ORDER BY TABLE_ROWS DESC; + + + | 阅读全文
posted @ 2022-09-05 09:18 LeoShi2020 阅读(2530) 评论(0) 推荐(0)