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 vote193 views1 answer
Oracle sql average
SQL
1 vote212 views1 answer
Oracle activate job
SQL
0 vote213 views3 answers
Sql drop all tables
SQL
0 vote222 views1 answer
Sql server information_schema temp tables
SQL
0 vote218 views1 answer
Sql server pivot rows to columns
SQL
8 votes238 views6 answers
Insert command in sql
SQL
0 vote215 views1 answer
How to remove quotes from a string in ssis load file
SQL
1 vote180 views1 answer
Firebase bigquery cloud message
SQL
6 votes205 views3 answers
Mysql server is not starting xampp
SQL
1 vote238 views1 answer
How to check all scheduled jobs in oracle
SQL