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
关联修改a表，将b表数据赋值给b表
update t_ifcert_productcfg cfg,t_project_invest invest
set cfg.sourceProductCode=invest.Project_id
where cfg.finClaimId=invest.Invest_id
本文标题：mysql关联更新update
本文链接：https://www.haomeiwen.com/subject/oshxlctx.html
网友评论