mysql - 有没有办法将两个更新查询合并为一个？

Question

我有多个更新查询。我想在一个声明中完成它们。查询是

update user set name = 'Something' where id = '1';
update user set name = 'Newthing' where id = '2';

我想要类似的东西

update user set name = 'Something' where id = '1' && update user set name = 'Newthing' where id = '2';

Answer 1

当然，只需使用 CASE 语句:

update user 
set name = 
    case when id = '1' then 'Something' 
         when id = '2' then 'Newthing' 
    end
where id in ('1','2')