This site gives two queries:

Determine dimensions of databases

SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024 
"Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;

Determine size all tables inside a database

SELECT TABLE_NAME, table_rows, data_length, index_length, 
round(((data_length + index_length) / 1024 / 1024),2) "Size in MB"
FROM information_schema.TABLES WHERE table_schema = "schema_name";

The very first query works properly, however the second query does not create a result set. It simply shows what they are called from the fields with no rows. How do i customize the second query to properly show how big dimensions of my tables during my database.

I Believe this really is better ..

show table status from database;

Replace "schema_name" using the title of 1 of your databases.

And use single-quotes for string literals, not double-quotes.