mysql关联表修改数据

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;