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 vote113 views1 answer
Oracle sql average
SQL
0 vote104 views1 answer
Vowels in sql
SQL
23 votes100 views6 answers
Delete all rows from table sql
SQL
0 vote119 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote104 views1 answer
How much table store postgres
SQL
0 vote104 views1 answer
Sql server list user permissions
SQL
0 vote103 views1 answer
Suse status MySQL
SQL
0 vote241 views1 answer
Get first match in each group mysql query
SQL
0 vote103 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote105 views1 answer
Sql datediff db2
SQL