MySQL查看表占用空间的大小

以字节（Byte）的格式展示：

SELECT
	data_length,
	index_length
FROM
	information_schema.TABLES
WHERE
	table_schema = 'db_name' 
	AND table_name = 'table_name';

以兆（MB）的格式展示：

SELECT
	concat( round( sum( data_length / 1024 / 1024 ), 2 ), 'MB' ) AS data_length_MB,
	concat( round( sum( index_length / 1024 / 1024 ), 2 ), 'MB' ) AS index_length_MB
FROM
	information_schema.TABLES
WHERE
	table_schema = 'db_name'
	AND table_name = 'table_name';