Answers for "update syntax in sql to set multiple values"

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)

Posted by: Guest on April-08-2021

Code answers related to "update syntax in sql to set multiple values"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "update syntax in sql to set multiple values"

Code answers related to "update syntax in sql to set multiple values"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "update syntax in sql to set multiple values"

Code answers related to "update syntax in sql to set multiple values"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us