update edu_exam a
set 班级=(select b.班号 from edu_student b where b.学号=a.学号)
where exists (select 1
from edu_student b
where b.学号=a.学号) and (a.班号='2019级会计2班' OR a.班号='2019级会计1班' )
MYSQL多表查询更新
最新推荐文章于 2023-11-15 08:27:40 发布
update edu_exam a
set 班级=(select b.班号 from edu_student b where b.学号=a.学号)
where exists (select 1
from edu_student b
where b.学号=a.学号) and (a.班号='2019级会计2班' OR a.班号='2019级会计1班' )