查出每个表数据量
select TABLE_NAME,TABLE_ROWS from information_schema.`TABLES` where TABLE_SCHEMA = '表名';
查每个库表字段数量
select TABLE_NAME,table_rows,data_type,column_type from information_schema.columns where TABLE_SCHEMA='表名';
查出每个表数据量
select TABLE_NAME,TABLE_ROWS from information_schema.`TABLES` where TABLE_SCHEMA = '表名';
查每个库表字段数量
select TABLE_NAME,table_rows,data_type,column_type from information_schema.columns where TABLE_SCHEMA='表名';