mysql 訂單商品查詢(xún)，Mysql當(dāng)中怎么查詢(xún)一個(gè)數(shù)據(jù)庫(kù)中所有為空的表？
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;
