mysql查询表的行数和空间使用及其它信息_MySQL
来源：动视网
责编：小采
时间：2020-11-09 19:15:38
mysql查询表的行数和空间使用及其它信息_MySQL
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
导读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
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,table_rows,data_length/1024/1024 from TABLES where table_schema='dbname'
记录
mysql查询表的行数和空间使用及其它信息_MySQL
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
