killpond · June 5, 2015 13:05
diff --git a/table_size.sql b/table_size.sql
 -- Replace "DATABASE" with the database you want information on

 SELECT 
    table_name AS 'Tables',
    round(((data_length + index_length) / 1024 / 1024),
            2) 'Size in MB'
 FROM
    information_schema.TABLES
 WHERE
    table_schema = 'DATABASE'
 ORDER BY (data_length + index_length) DESC;
	-- Replace "DATABASE" with the database you want information on

	SELECT
	table_name AS 'Tables',
	round(((data_length + index_length) / 1024 / 1024),
	2) 'Size in MB'
	FROM
	information_schema.TABLES
	WHERE
	table_schema = 'DATABASE'
	ORDER BY (data_length + index_length) DESC;
No results found