关联修改：
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
MySQL关联修改
www.beicaiduo.com
关联修改：
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