//10000条数据大概60秒
update product_sku_copy2 s, product_sku_bakk c set s.pCost = c.purchasePrice where s.pCode = c.pCode;
//10000条数据大概20秒
update product_sku_copy1 s set pCost = (select purchasePrice from product_sku_bakk where pCode = s.pCode);
使用一个表去关联更新另一个表字段
最新推荐文章于 2022-09-23 10:42:52 发布