同一列但具有多个WHERe子句的MYSQL UPDATE SET

这样的事情应该为您工作：

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    ENDWHERe 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/