UPDATE A as a
INNER JOIN B as b ON b.aid = a.id
AND a.is_deleted = 0
SET a.字段1=b.value1,
a.字段2=b.value2,
a.字段3=b.value3
WHERE a.id=b.aid
# 其他限制条件
AND a.字段4=? ;
————————————————
更新id为 102 ，101 的sku字段-->
update shop_db.t_goods_description
set g_sku = case gid
when 102 then '5'
when 101 then '5'
end where gid in(102,101)
more:https://blog.csdn.net/qq_38807606/article/details/114300395
标签：sku,批量,mysq,字段,102,101,id From： https://www.cnblogs.com/yangsanluo/p/16788747.html