DB2 INSERT Statement

Code Example

## DB2 INSERT Statement

INSERT adds new rows to a table.

### Basic Syntax
\`\`\`sql
INSERT INTO table-name (columns)
VALUES (values)
\`\`\`

### Insert Single Row
With all columns:
\`\`\`sql
INSERT INTO EMP VALUES ('E001', 'JOHN', 50000)
\`\`\`

### Insert with Column List
Specify columns explicitly:
\`\`\`sql
INSERT INTO EMP (EMP_ID, NAME) VALUES ('E002', 'JANE')
\`\`\`

### Insert from SELECT
\`\`\`sql
INSERT INTO EMP_BACKUP
SELECT * FROM EMP WHERE STATUS = 'A'
\`\`\`

### Insert Multiple Rows
\`\`\`sql
INSERT INTO EMP VALUES
    ('E001', 'JOHN', 50000),
    ('E002', 'JANE', 55000)
\`\`\`

### NULL Values
Omit column or use NULL keyword.

### Default Values
Use DEFAULT keyword for default value.