SELECT 
    table_name AS '表名',
    round(data_length / 1024 / 1024, 2) AS '数据大小(MB)',
    round(index_length / 1024 / 1024, 2) AS '索引大小(MB)',
    round((data_length + index_length) / 1024 / 1024, 2) AS '总大小(MB)'
FROM 
    information_schema.tables 
WHERE 
    table_schema = '数据库名'  -- 替换为你的数据库名
    AND table_name = '表名';  -- 替换为你的表名

SELECT 
    table_name AS '表名',
    round(data_length / 1024 / 1024, 2) AS '数据大小(MB)',
    round(index_length / 1024 / 1024, 2) AS '索引大小(MB)',
    round((data_length + index_length) / 1024 / 1024, 2) AS '总大小(MB)'
FROM 
    information_schema.tables 
WHERE 
    table_schema = '数据库名'  -- 替换为你的数据库名
ORDER BY 
    (data_length + index_length) DESC;