Update table sql multiple set

-- CANT do multiple sets but can do case
UPDATE table
SET ID = CASE WHEN ID = 2555 THEN 111111259 
              WHEN ID = 2724 THEN 111111261
              WHEN ID = 2021 THEN 111111263
              WHEN ID = 2017 THEN 111111264
         END
WHERE ID IN (2555,2724,2021,2017)

Source: stackoverflow.com

Similar codes

1 vote315 views1 answer
Oracle show execution plan
SQL
15 votes416 views2 answers
Sql order by alphabetical
SQL
0 vote225 views1 answer
Sql count how many times a value appears
SQL
0 vote283 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote284 views1 answer
Guid string to binary better
SQL
5 votes297 views1 answer
Oracle nls session
SQL
0 vote280 views1 answer
Mysql select where field like in list
SQL
0 vote252 views1 answer
Postgresql get current user name
SQL
0 vote296 views1 answer
Allow null in psql
SQL
0 vote291 views1 answer
Get who is hired in february in sql
SQL