컴퓨터 관련/내 업무(비공개게시물)
쓸만한 쿼리
보뇨
2024. 2. 6. 11:26
반응형
SELECT
TABLE_NAME AS `Table`,
ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA = "test"
ORDER BY
(DATA_LENGTH + INDEX_LENGTH)
DESC;
반응형