Add row count.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Fri, 22 Jan 2016 22:14:58 +0200
changeset 1879 b5f927fa28ce
parent 1878 25c0fb1dfc22
child 1880 ff2e0241303c
Add row count.
mysql.rst
--- a/mysql.rst	Fri Jan 22 22:13:42 2016 +0200
+++ b/mysql.rst	Fri Jan 22 22:14:58 2016 +0200
@@ -75,8 +75,9 @@
   GROUP BY table_schema;
 
   SELECT
-    table_schema as `Database`,
-    table_name AS `Table`,
+    table_schema AS `Database`,
+    table_name,
+    table_rows,
     round(((data_length + index_length) / 1024 / 1024), 2) `Size, MiB`
   FROM information_schema.TABLES
   ORDER BY (data_length + index_length) DESC;