nikitug · June 25, 2010 13:33
diff --git a/mysql_table_size.sql b/mysql_table_size.sql
 SELECT
    table_name,
    engine,
    ROUND(data_length/1024/1024,2) AS total_size_mb,
    table_rows
 FROM
    information_schema.tables
 WHERE
    table_schema=DATABASE();
	SELECT
	table_name,
	engine,
	ROUND(data_length/1024/1024,2) AS total_size_mb,
	table_rows
	FROM
	information_schema.tables
	WHERE
	table_schema=DATABASE();