Answers for "return size of tables in mysql"

return size of tables in mysql

SELECT 
     table_schema as `Database`, 
     table_name AS `Table`, 
     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
FROM information_schema.TABLES 
ORDER BY (data_length + index_length) DESC;

Posted by: Guest on October-01-2021

Code answers related to "return size of tables in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "return size of tables in mysql"

Code answers related to "return size of tables in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "return size of tables in mysql"

Code answers related to "return size of tables in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us