12345USEinformation_schema;--Mysql一个数据库所有有数据的表SELECTtable_schema,table_name,table_rowsFROMTABLESWHERETABLE_SCHEMA='test'ANDtable_rows!=0ORDERBYtable_rowsDESC;--Mysql一个数据库中所有为空的表SELECTtable_schema,table_name,table_rowsFROMTABLESWHERETABLE_SCHEMA='test'ANDtable_rows=0ORDERBYtable_name;
