SELECT
TABLE_NAME AS 表名,
TABLE_COMMENT AS 表备注,
truncate((DATA_LENGTH+INDEX_LENGTH)/(1024*1024),4) AS `大小/MB`,
(
SELECT
count( * )
FROM
information_schema.`COLUMNS`
WHERE
TABLE_SCHEMA = '数据库'
AND TABLE_NAME = t.TABLE_NAME
) AS 字段数量 ,
(
SELECT SUM(table_rows) FROM information_schema.TABLES WHERE TABLE_SCHEMA = '数据库' AND TABLE_NAME = t.TABLE_NAME
) AS 数据量
FROM
information_schema.TABLES AS t
WHERE
table_schema = '数据库'
mysql查看数据每张表的使用情况,存储空间
于 2022-11-28 21:27:07 首次发布