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 vote293 views2 answers
Temp Space
SQL
0 vote271 views1 answer
Mysql select field if condition
SQL
0 vote278 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
1 vote272 views1 answer
Sql server datetime vs datetime2
SQL
0 vote281 views1 answer
Plpgsql raise notice
SQL
2 votes284 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
3 votes272 views1 answer
RENAME table pl sql
SQL
0 vote276 views1 answer
Like date sql server not working
SQL
-1 vote211 views3 answers
Ubuntu install mssql
SQL
0 vote256 views1 answer
Mql5 list all available symbols
SQL