SQL statement in MySQL that queries all databases for disk space size and the size of all tables in a single library

Query the SQL statement that all databases consume disk space size:

SelectTable_schema, Concat (truncate(sum(data_length)/1024x768/1024x768,2),'MB') asData_size,concat (truncate(sum(index_length)/1024x768/1024x768,2),'MB') asindex_size fromInformation_schema.tablesGroup  byTable_schemaOrder  byData_lengthdesc;

SQL statements that query the size of all table disks in a single library:

SelectTABLE_NAME, CONCAT (truncate(Data_length/1024x768/1024x768,2),'MB') asData_size,concat (truncate(Index_length/1024x768/1024x768,2),'MB') asindex_size fromInformation_schema.tableswhereTable_schema= 'TestDB'Group  bytable_nameOrder  byData_lengthdesc;

Note Replace the above testdb for the specific database name

SQL statement in MySQL that queries all databases for disk space size and the size of all tables in a single library