SQL 用不同的参数或值更新多条记录 [英] SQL update multiple records with different paramaters or values

问题描述

我知道这行不通:

UPDATE `states` SET `country_id` = '83', `position` = (1,2,3) WHERE `states`.`id` IN (381, 378, 380);

有没有办法根据

id = 381; position = 1
id = 378; position = 2
id = 380; position = 3

谢谢.

推荐答案

最简单的是使用三个单独的查询.

The simplest is to use three separate queries.

可以使用单个查询，但更复杂:

It is possible with a single query, but more complicated:

UPDATE states
SET country_id = '83',
    position = CASE id WHEN 381 THEN 1
                       WHEN 378 THEN 2
                       WHEN 370 THEN 3 END
WHERE id IN (381, 378, 380)

这篇关于SQL 用不同的参数或值更新多条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！