List MySQL Table and Index Size

MariaDB [(none)]> SELECT table_schema "DB Name", Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
 FROM information_schema.tables
 GROUP BY table_schema;
+--------------------+---------------+
| DB Name            | DB Size in MB |
+--------------------+---------------+
| hope               |       75714.0 |
| information_schema |           0.2 |
| mysql              |           1.9 |
| performance_schema |           0.0 |
+--------------------+---------------+

Source: forknerds.com

Similar codes

1 vote369 views1 answer
Round function in sql oracle
SQL
3 votes346 views3 answers
Concatenation in sql
SQL
2 votes387 views1 answer
Oracle Column Names of a table
SQL
0 vote345 views1 answer
Install sql server windows 10
SQL
6 votes333 views5 answers
Get current date sql
SQL
0 vote361 views1 answer
Postgresql create table many-to-many
SQL
31 votes363 views2 answers
Grant all priviledges to mysql user
SQL
3 votes334 views5 answers
Mysql get last inserted id
SQL
0 vote334 views1 answer
View acl table oracle
SQL
2 votes333 views1 answer
How to search table name in stored procedure in sql server
SQL