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 vote218 views1 answer
Database db connection string format
SQL
0 vote218 views1 answer
Change permission to database mysql
SQL
0 vote239 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote195 views1 answer
Sql server whoami
SQL
6 votes220 views3 answers
Mysql create database utf8
SQL
16 votes229 views6 answers
Mysql find duplicates in same table
SQL
1 vote211 views3 answers
Date_add mysql
SQL
1 vote210 views1 answer
Set autoincrement to 0
SQL
0 vote206 views1 answer
Sql server order by nulls last
SQL
0 vote196 views1 answer
Connect postgresql using a connection string
SQL