UPDATE contract_info a LEFT JOIN sys_support c ON a.`supplier_name` = c.name
SET a.supplier_id = c.id
mysql 连表更新
最新推荐文章于 2024-05-17 13:53:28 发布
UPDATE contract_info a LEFT JOIN sys_support c ON a.`supplier_name` = c.name
SET a.supplier_id = c.id