获取缺失主键表信息的MYSQL语句
SELECTa.`TABLE_SCHEMA`ASDB_NAME,a.`TABLE_NAME`,a.`TABLE_ROWS`,a.`ENGINE`--,a.*FROMinformation_schema.`TABLES`aLEFTJOINin
信息语句
SELECTa.`TABLE_SCHEMA`ASDB_NAME,a.`TABLE_NAME`,a.`TABLE_ROWS`,a.`ENGINE`--,a.*FROMinformation_schema.`TABLES`aLEFTJOINin