修改数据库名 table_schema 为你自己的

SELECT
a.table_schema ,
a.table_name ,
concat(a.TABLE_ROWS, "条"),
concat(round((DATA_LENGTH / 1024 / 1024) + (INDEX_LENGTH / 1024 / 1024),2) ,'MB') total_size ,
concat(round(DATA_LENGTH / 1024 / 1024 , 2) ,'MB') AS data_size ,
concat(round(INDEX_LENGTH / 1024 / 1024 , 2) ,'MB') AS index_size
FROM
information_schema.TABLES a
WHERE
a.table_schema = 'te_order';