格式:update 表1 set 表1.fields1=表2.field1 ,表1.fields2=表2.field2 .......from 表1
inner join 表2
on 表1与表2的关联条件
例子如下:
update branchMapping_bak1 set vo=branchMapping_bak.virtualoffice from branchMapping_bak1
inner join branchMapping_bak
on branchMapping_bak1.branchName= branchMapping_bak.branchName and
branchMapping_bak1.businessType=branchMapping_bak1.businessType
and branchMapping_bak.sort=branchMapping_bak1.sort
知数堂mysql实战加优化课程提供了很多实战和优化的案例。add_wechat_itfighter 来获取