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

2 votes155 views1 answer
Q operator in oracle
SQL
1 vote159 views1 answer
Median mysql
SQL
4 votes153 views1 answer
Wilayah indonesia database
SQL
0 vote146 views1 answer
Python sqlalchemy orm to select null values
SQL
18 votes149 views3 answers
Find column name in database
SQL
0 vote155 views1 answer
Sql check if column exists
SQL
0 vote144 views2 answers
Plsql regex match whole word
SQL
0 vote200 views1 answer
Sql declare variable single line
SQL
0 vote183 views1 answer
Oracle running queries
SQL
0 vote152 views2 answers
Sql join on comma separated field
SQL