MySQL关联修改

关联修改:

UPDATE scm_material_contract m Left JOIN scm_material_base b ON m.material_id=b.material_id set m.material_name=b.material_name

posted @ 2020-02-15 11:33  hoge  阅读(2292)  评论(0编辑  收藏  举报