mysq根据id批量进行修改

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)