SELECT
  TABLE_SCHEMA AS '数据库名',
  TABLE_NAME AS '表名',
  ROUND(DATA_LENGTH / 1024 / 1024 / 1024, 2) AS '数据大小(GB)',
  ROUND(INDEX_LENGTH / 1024 / 1024 / 1024, 2) AS '索引大小(GB)',
  ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024 / 1024, 2) AS `总占用大小(GB)`  -- 别名加反引号
FROM
  INFORMATION_SCHEMA.TABLES
WHERE
  TABLE_SCHEMA = 'test'  -- 替换为你的库名
ORDER BY
  `总占用大小(GB)` DESC;  -- 排序时也加反引号