DB2 UPDATE Statement

Code Example

## DB2 UPDATE Statement

UPDATE modifies existing data in a table.

### Basic Syntax
\`\`\`sql
UPDATE table-name
SET column = value [, column = value...]
WHERE condition
\`\`\`

### Simple Update
\`\`\`sql
UPDATE EMP
SET SALARY = 55000
WHERE EMP_ID = 'E001'
\`\`\`

### Update Multiple Columns
\`\`\`sql
UPDATE EMP
SET SALARY = 60000,
    DEPT = 'IT'
WHERE EMP_ID = 'E001'
\`\`\`

### Update with Expression
\`\`\`sql
UPDATE EMP
SET SALARY = SALARY * 1.10
WHERE RATING = 'A'
\`\`\`

### Update with Subquery
\`\`\`sql
UPDATE EMP
SET SALARY = (SELECT AVG(SALARY) FROM EMP)
WHERE DEPT = 'NEW'
\`\`\`

### WARNING: Without WHERE
Updates ALL rows in table!