1.关联表修改数据
UPDATE pm_device t INNER JOIN pm_rel_device_area t1 on t.DEVICE_CODE = t1.DEVICE_CODE
set t.SP_CODE = t1.SP_CODE;
2.跨库关联表修改数据
update t_device t INNER JOIN conet_sscs.pm_device t1 ON t.DEVICE_CODE = t1.DEVICE_CODE
set t.SP_CODE = t1.SP_CODE;