mysql关联更新update，mysql关联修改

关联修改a表，将b表数据赋值给b表

update  t_ifcert_productcfg cfg,t_project_invest invest 
set cfg.sourceProductCode=invest.Project_id
where cfg.finClaimId=invest.Invest_id