数据库中表中空间大小

SELECT CONCAT(table_schema,'.',table_name) AS 'Table Name', CONCAT(ROUND(table_rows/10000,2),' 万') AS 'Number of Rows', CONCAT(ROUND(data_length/(1024*1024),2),' MB') AS 'Data Size', CONCAT(ROUND(index_length/(1024*1024),2),' MB') AS 'Index Size' , CONCAT(ROUND((data_length+index_length)/(1024*1024),2),' MB') AS 'Total', CONCAT(AVG_ROW_LENGTH,' Byte') As 'Row_Length'
FROM information_schema.TABLES
WHERE table_schema LIKE 'DB_NAME';