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 vote133 views1 answer
Oracle call a function in a insert statement
SQL
0 vote124 views1 answer
List mysql tables and views
SQL
8 votes130 views5 answers
Alter table add column with default value
SQL
0 vote135 views1 answer
Mysql subdate
SQL
1 vote136 views1 answer
Mysql list bigger table
SQL
7 votes140 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote134 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote105 views1 answer
Sql injection mitigation
SQL
0 vote145 views1 answer
How to get nth number in sql
SQL
0 vote124 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL