Differences

This shows you the differences between two versions of the page.

--- table_size [2017/02/23 08:50] – luke7858
+++ table_size [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 === Size of a tables in a db ===
-**__Note:__** You will need to replace DATABASE_NAME and TABLE_NAME.
+**__Note:__** You will need to replace **__DATABASE_NAME__**
 <sxh bash>
 SELECT table_name AS "Table",
-     round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
+round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
 FROM information_schema.TABLES