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 vote126 views1 answer
Mysql take number in string
SQL
0 vote126 views1 answer
Sql alter table order by
SQL
0 vote117 views1 answer
Mysql default uuid
SQL
0 vote102 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote133 views1 answer
Sql cursor example multiple columns
SQL
0 vote118 views1 answer
How to retrive the today date sql
SQL
0 vote123 views1 answer
Get number of rows in every table mysql
SQL
0 vote120 views1 answer
Select from column mysql
SQL
9 votes121 views2 answers
Sql server check table exists
SQL
1 vote124 views1 answer
Sqlalchemy order by descending
SQL