Search
Search

How to update multiple columns in single update statement in DB2

SuperMan Published at Dev
14
Superman

I want to update multiple columns of a table in DB2 with single Update statement.

Any hint or idea will be appreciable. Thanks.

Gordon Linoff

The update statement in all versions of SQL looks like:

update table
    set col1 = expr1,
        col2 = expr2,
        . . .
        coln = exprn
    where some condition

So, the answer is that you separate the assignments using commas and don't repeat the set statement.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Multiple SET in single UPDATE statement?

From Dev

How to update only matching columns in db2

From Dev

update multiple columns with case/if statement?

From Dev

How to update the same column for multiple rows in DB2

From Dev

Incremental Update statement in DB2

From Dev

How to use multiple columns in WHERE clause in SQL Server in update statement

From Dev

How to concatenate columns in update statement

From Dev

update with multiple inner joins in db2

From Dev

Insert and Update multiple values in single SQL Statement

From Dev

db2 sql update to calculate totals column single update

From Dev

Is bulk update faster than single update in db2?

From Dev

update multiple columns using case statement in sql

From Dev

KDB multiple columns update statement length error

From Dev

Update multiple columns based on a single condition in kdb

From Dev

Create multiple columns in pandas dataframe in single update

From Dev

How can I have inner join and a case expresion in a DB2 update statement?

From Dev

How to update DB2 table with a join?

From Dev

How to update exactly one record and select updated row in a single db2 query

From Dev

MySQL a single update statement (+) =

From Dev

How to update multiple rows of multiple columns with single value having same condition for every column

From Dev

single UPDATE query to modify multiple columns on multiple conditions SQL

From Dev

Update multiple columns with multiple values in one single table

From Dev

Update multiple columns based off another table in DB2 V5R4M0

From Dev

Update 2 columns for a single case condition

From Dev

Update or Insert Multiple Rows into a Table in DB2

From Dev

How to condense multiple update statement - SQL

From Dev

How can I UPDATE SQL using values from multiple columns of a select statement

From Dev

How to do multiple columns update on different where condition using PostgreSQL Upsert Using INSERT ON CONFLICT statement

From Java

insert/update/delete multiple tables in single SQL statement

Related Related

  1. 1

    Multiple SET in single UPDATE statement?

  2. 2

    How to update only matching columns in db2

  3. 3

    update multiple columns with case/if statement?

  4. 4

    How to update the same column for multiple rows in DB2

  5. 5

    Incremental Update statement in DB2

  6. 6

    How to use multiple columns in WHERE clause in SQL Server in update statement

  7. 7

    How to concatenate columns in update statement

  8. 8

    update with multiple inner joins in db2

  9. 9

    Insert and Update multiple values in single SQL Statement

  10. 10

    db2 sql update to calculate totals column single update

  11. 11

    Is bulk update faster than single update in db2?

  12. 12

    update multiple columns using case statement in sql

  13. 13

    KDB multiple columns update statement length error

  14. 14

    Update multiple columns based on a single condition in kdb

  15. 15

    Create multiple columns in pandas dataframe in single update

  16. 16

    How can I have inner join and a case expresion in a DB2 update statement?

  17. 17

    How to update DB2 table with a join?

  18. 18

    How to update exactly one record and select updated row in a single db2 query

  19. 19

    MySQL a single update statement (+) =

  20. 20

    How to update multiple rows of multiple columns with single value having same condition for every column

  21. 21

    single UPDATE query to modify multiple columns on multiple conditions SQL

  22. 22

    Update multiple columns with multiple values in one single table

  23. 23

    Update multiple columns based off another table in DB2 V5R4M0

  24. 24

    Update 2 columns for a single case condition

  25. 25

    Update or Insert Multiple Rows into a Table in DB2

  26. 26

    How to condense multiple update statement - SQL

  27. 27

    How can I UPDATE SQL using values from multiple columns of a select statement

  28. 28

    How to do multiple columns update on different where condition using PostgreSQL Upsert Using INSERT ON CONFLICT statement

  29. 29

    insert/update/delete multiple tables in single SQL statement

HotTag

Archive