Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mysql list bigger table

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;
Source by tableplus.com #
 
PREVIOUS NEXT
Tagged: #mysql #list #bigger #table
ADD COMMENT
Topic
Name
2+7 =