scm中mysql作用_SCM 关联表修改

1、用join的方式，在mysql中行不通：

SELECT b.remarks,b.DictSortCode,c.* from scm_dict_config c left join scm_dict_base b on c.DictSortCodeScm=b.remarks

update scm_dict_config set c.DictSortCode=b.DictSortCode from scm_dict_config c left join scm_dict_base b on c.DictSortCodeScm=b.remarks

where (b.DictSortCode!='' and b.DictSortCode is not null)

update scm_dict_config c,scm_dict_base b set c.DictSortCode=b.DictSortCode where c.DictSortCodeScm=b.remarks

and (b.DictSortCode!='' and b.DictSortCode is not null)

SELECT b.remarks,b.DictSortCode,c.DictSortCode from scm_dict_config c left join scm_dict_base b on c.DictSortCodeScm=b.remarks

where (b.DictSortCode!='' and b.DictSortCode is not null)

SELECT * from org_bm_tmp

-- 修改org编码

update scm_org c,org_bm_tmp b set c.org_bm=b.org_bm where c.orgName=b.org_name

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！