Difference between revisions of "MySQL"

MySQL (view source)

213 bytes added , 22:13, 22 October 2013

→‎SHOW etc: Added "Database Sizes"

2,187

edits

@@ Line 264: / Line 264: @@
 SHOW INDEX FROM table;                                 # Show tables index/key information
 SHOW CREATE TABLE table;                               # Shows syntax that would be used to recreate a table
+</source>
+==== Database Sizes ====
+<source lang="mysql">
+SELECT table_schema "Database", Round(Sum(data_length + index_length) / 1024 / 1024, 1) "Size (MB)" FROM information_schema.tables GROUP BY table_schema;
 </source>