brandtg · April 28, 2017 19:59
diff --git a/table-size.sh b/table-size.sh
 #!/bin/bash

 SQL=$(cat << EOF
 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;
 EOF)

 mysql -e "$SQL" $@
	#!/bin/bash

	SQL=$(cat << EOF
	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;
	EOF)

	mysql -e "$SQL" $@