Answers for "how much every mysql database record takes from diskspace"

SQL
1

how much every mysql database record takes from diskspace

SELECT table_schema as 'Database Name', 
        sum( data_length + index_length ) as 'Size-Bytes',       
        round((sum(data_length + index_length) / 1024 / 1024), 4) as 'Size-MB'
 FROM     information_schema.TABLES
 GROUP BY table_schema
Posted by: Guest on December-07-2020

Code answers related to "how much every mysql database record takes from diskspace"

Code answers related to "SQL"

Browse Popular Code Answers by Language