moodLearning Wiki

Differences

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

Link to this comparison view

mysql-notes [2019/04/15 22:28]
serbizadmin created
mysql-notes [2020/06/13 23:10]
Line 1: Line 1:
-====== DB Size ====== +
-<​code>​ +
-SELECT table_schema "​dbname"​ +
-     , SUM(data_length + index_length) / (1024 * 1024) "​Database Size in MB" +
-FROM information_schema.TABLES +
-GROUP BY table_schema;​ +
-</​code>​+