这样的事情应该为您工作：
UPDATE CustomerDetails_COPY
SET Category_ID = CASE Category_ID
WHEN 2 THEN 10
WHEN 3 THEN 9
WHEN 4 THEN 12
WHEN 5 THEN 11
END
WHERE Category_ID IN (2,3,4,5)
另外，如Simon所建议的，您可以这样做来避免输入两次值：
UPDATE CustomerDetails_COPY
SET Category_ID = CASE Category_ID
WHEN 2 THEN 10
WHEN 3 THEN 9
WHEN 4 THEN 12
WHEN 5 THEN 11
ELSE Category_ID
END
资料来源：http ://www.karlrixon.co.uk/writing/update-multiple-rows-with-different-values-and- a-single-sql-query/
602392714
清零编程群