> For the complete documentation index, see [llms.txt](https://php-etl.gitbook.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://php-etl.gitbook.io/docs/loaders/insertupdate.md).

# Insert/Update

Inserts data into a database table.

```php
$etl->load('insert_update', 'table_name', $options);
```

## Options

### Columns

Columns that will be loaded. If `null`, all columns in the process will be inserted/updated.

| Type  | Default value |
| ----- | ------------- |
| array | `null`        |

To select which columns will be loaded, use an array with the columns list:

```php
$options = ['columns' => ['id', 'name', 'email']];
```

To map columns from the etl process to the database table, use an associative array where the `key` is the name of the process column and the `value` is the table column:

```php
$options = ['columns' => [
    'id' => 'user_id',
    'name' => 'full_name',
]];
```

### Connection

Name of the database connection to use.

| Type   | Default value |
| ------ | ------------- |
| string | default       |

```php
$options = ['connection' => 'app'];
```

### Key

List of primary keys or identifiers of the table.

| Type  | Default value |
| ----- | ------------- |
| array | `['id']`      |

```php
$options = ['key' => ['id', 'type']];
```

### Timestamps

Populates the `created_at` and/or `updated_at` columns with the current timestamp when inserting or updating a row.

| Type    | Default value |
| ------- | ------------- |
| boolean | `false`       |

```php
$options = ['timestamps' => true];
```

### Transaction

Indicates if the loader will perform database transactions.

| Type    | Default value |
| ------- | ------------- |
| boolean | `true`        |

```php
$options = ['transaction' => false];
```

### Commit Size

Transaction commit size. The transaction option must be enabled.

| Type | Default value |
| ---- | ------------- |
| int  | 100           |

```php
$options = ['commit_size' => 500];
```