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

0 vote147 views1 answer
Normalization in database
SQL
0 vote134 views1 answer
Mysql docker image for macbook m1
SQL
1 vote132 views1 answer
Create temporal table in sql
SQL
0 vote193 views1 answer
Mysql readable output
SQL
0 vote137 views1 answer
Mysql url
SQL
2 votes122 views1 answer
Oracle create directory
SQL
0 vote137 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
1 vote142 views1 answer
Convert varchar to int in sqlite
SQL
0 vote142 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote140 views1 answer
Oracle string length
SQL