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 vote169 views1 answer
Simple project for database
SQL
1 vote185 views1 answer
Mysql Case sum
SQL
1 vote162 views1 answer
Oracle first row
SQL
0 vote160 views1 answer
Case insensitive sql
SQL
0 vote165 views1 answer
How to set sql_mode for a query in CI model
SQL
4 votes193 views2 answers
Dbms output
SQL
1 vote162 views1 answer
Mysql check table exists
SQL
3 votes180 views1 answer
Oracle apex message quit website
SQL
0 vote168 views1 answer
Mysql count unique in group statement
SQL
4 votes178 views1 answer
Create column mysql terminal
SQL