UPDATE ecm_goods_weight_new SET
activity_score = CASE goods_id
WHEN 2085986 THEN 111
WHEN 2086010 THEN 666
WHEN 2086018 THEN 777
WHEN 2086019 THEN 888
END,
goods_name = CASE goods_id
WHEN 2085986 THEN 222
WHEN 2086010 THEN 333
WHEN 2086018 THEN 444
WHEN 2086019 THEN 555
END
WHERE goods_id IN (2085986,2086010,2086018,2086019)