mysql查询表的行数和空间使用及其它信息_MySQL:use information_schema;select concat(round(sum(DATA_LENGTH/1024/1024), 2), 'MB') as data from TABLES;select concat(round(sum(DATA_LENGTH/1024/1024), 2), 'MB') as data from TABLES where table_schema='dbname';select table_schema,table_name,ta