12345USEinformation_schema;--Mysql一個(gè)數(shù)據(jù)庫(kù)所有有數(shù)據(jù)的表SELECTtable_schema,table_name,table_rowsFROMTABLESWHERETABLE_SCHEMA='test'ANDtable_rows!=0ORDERBYtable_rowsDESC;--Mysql一個(gè)數(shù)據(jù)庫(kù)中所有為空的表SELECTtable_schema,table_name,table_rowsFROMTABLESWHERETABLE_SCHEMA='test'ANDtable_rows=0ORDERBYtable_name;