1.修改一列:
update A a,B b
set a.name=b.name
where a.id=b.id;
2.修改多列:
update A a,B b
set a.name=b.name,a.code=b.code
where a.id=b.id;
3.采用子查询
update A a set a.name=(select name from B b where a.id=b.id);
1.修改一列:
update A a,B b
set a.name=b.name
where a.id=b.id;
2.修改多列:
update A a,B b
set a.name=b.name,a.code=b.code
where a.id=b.id;
3.采用子查询
update A a set a.name=(select name from B b where a.id=b.id);