--修改数据[MSSQL专用]
update s set s.classId=sc.classId from student s,student_class sc where s.studentId=sc.studentId
--修改数据[MySQL专用]
update Student s,Student_Class sc set s.classId=sc.classId where s.studentId=sc.studentId;
update s set s.classId=sc.classId from student s,student_class sc where s.studentId=sc.studentId
--修改数据[MySQL专用]
update Student s,Student_Class sc set s.classId=sc.classId where s.studentId=sc.studentId;