SQL中批量更新数据表中多条记录

 

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)