联表更新 UPDATE credit_detail cd, train_course tc SET cd.year_id = tc.year_id WHERE cd.year_id IS NULL AND cd.train_course_id = tc.id