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 vote230 views1 answer
How to print sql query
SQL
0 vote214 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote205 views1 answer
2020 new year
SQL
1 vote223 views1 answer
Oracle compile schema
SQL
3 votes222 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
0 vote227 views1 answer
How to change the field size of an existing column
SQL
0 vote257 views1 answer
Mysqlimport
SQL
12 votes204 views2 answers
Delete entries in postgresql
SQL
14 votes290 views1 answer
How to export db from mysql
SQL
0 vote194 views1 answer
Psql list rules
SQL