UPDATE
student_culture_rel_t rel,
student_teacher_t t
SET
rel.TEACHER_ID_ = t.TEACHER_ID_
WHERE rel.STUDENT_ID_ = t.STUDENT_ID_
mysql 批量更新不同的值
最新推荐文章于 2024-02-26 13:58:30 发布
UPDATE
student_culture_rel_t rel,
student_teacher_t t
SET
rel.TEACHER_ID_ = t.TEACHER_ID_
WHERE rel.STUDENT_ID_ = t.STUDENT_ID_