真正批量更新的含义

圣英神士

于 2020-01-07 16:21:03 发布

阅读量219

点赞数

本文链接：https://blog.youkuaiyun.com/qq_34627002/article/details/103876790

版权

UPDATE send_order set send_code= case when pk_send_order=1 and pk_goods_owner=205 then '辛忠原' when pk_send_order=2 and pk_goods_owner=204 then '辛忠原2' end,
send_describe= case when pk_send_order=1 and pk_goods_owner=205 then '阿弥陀佛' end where pk_send_order in (1,2,3) and pk_goods_owner in (205,204)

更新要加else 否则会需将匹配不到的更新为空

UPDATE send_order set send_code= case when pk_send_order=1 and pk_goods_owner=205 then '辛忠原' when pk_send_order=2 and pk_goods_owner=204 then '辛忠原2' else send_code end,
send_describe= case when pk_send_order=1 and pk_goods_owner=205 then '阿弥陀佛' else send_describe end where pk_send_order in (1,2,3) and pk_goods_owner in (205,204)