Answers for "mysql list tables size"

SQL
1

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;
Posted by: Guest on January-01-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language