1、修改1列
update student s, person p
set p.person_name = s.name
where s.person_code = p.code;
2、修改多列
update a, b
set a.title=b.title, a.name=b.name
where a.id=b.id
3、子查询
update student s set city_name = (select name from city where code = s.city_code);