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 vote199 views1 answer
Mysql reset wp_options
SQL
0 vote178 views3 answers
Select random sql
SQL
1 vote169 views1 answer
Mysql find tables with column name
SQL
2 votes185 views1 answer
Oracle list grants on package
SQL
0 vote182 views1 answer
Sql server select ignore dupplicates
SQL
3 votes167 views3 answers
Mysql select table names
SQL
0 vote201 views1 answer
Sql cmd no truncate
SQL
1 vote179 views4 answers
Between vs in sql
SQL
1 vote162 views1 answer
Mysql get last insert id
SQL
0 vote133 views1 answer
Update row in sqlite python
SQL