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)

more:https://blog.csdn.net/qq_38807606/article/details/114300395

原文地址：http://www.cnblogs.com/yangsanluo/p/16788747.html