Mysql将一个表的数据通过id关联更新至另一个表

~程序员小白~

已于 2024-03-06 09:37:25 修改

阅读量310

点赞数 3

文章标签： mysql java

于 2024-02-28 10:42:28 首次发布

本文链接：https://blog.csdn.net/qq_31957463/article/details/136339693

版权

该篇文章详细描述了如何通过SQL语句更新plan_purchase表中的数据，通过JOIN操作将sale_contract_management表的相关字段如合同名称、编号等进行同步。

摘要由CSDN通过智能技术生成

通过sql语句更新：

UPDATE plan_purchase AS pp
JOIN sale_contract_management AS scm ON pp.sale_contract_id = scm.id
SET pp.contract_name = scm.contract_name,
	pp.contract_number = scm.contract_number,
	pp.customer_name = scm.customer_name,
	pp.contract_amount = scm.contract_amount,
	pp.customer_contractor = scm.customer_contractor,
	pp.customer_contractor_phone = scm.customer_contractor_phone,
	pp.maintenance_department = scm.maintenance_department,
	pp.contract_maintenance_user = scm.contract_maintenance_user,
	pp.contract_maintenance_user_id = scm.contract_maintenance_user_id,
	pp.shipping_address = scm.shipping_address;