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 vote189 views1 answer
Mysql a from on this page has
SQL
0 vote262 views1 answer
SQL Server Enterprise
SQL
0 vote186 views1 answer
Mysql where in keep order
SQL
0 vote181 views1 answer
Min mysql
SQL
2 votes147 views4 answers
Mysql change database character set to utf8mb4
SQL
3 votes186 views1 answer
Oracle apex warning message
SQL
3 votes169 views1 answer
Postgresql if null then 0
SQL
7 votes176 views1 answer
Append column sql
SQL
0 vote183 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote181 views1 answer
Ffeathers express mysql application users login
SQL