SELECT
classes.*FROM
university_classes classes
WHERE
classes.sign_in_amount =(SELECTcount(*)FROM university_classes_record record WHERE record.classes_id = classes.id );
2 把第一步查询出需要修复的数据作为更新条件的子查询,修复关联数据
UPDATE university_classes
SET sign_in_amount =(SELECTcount(*)FROM university_classes_record WHERE university_classes_record.classes_id = university_classes.id )WHERE
university_classes.sign_in_amount !=(SELECTcount(*)FROM university_classes_record WHERE university_classes_record.classes_id = university_classes.id );
1先查询出哪些是需要修复的数据SELECT classes.* FROM university_classes classes WHERE classes.sign_in_amount = ( SELECT count( * ) FROM university_classes_record record WHERE record.classes_id = classes.id ); 2 把第一步查询出需要修复的数据作为更新条件的子查询,修复关联数据UPDATE university_cl