# SharpenDB UPDATE (/docs/workflows/reference/category/data/sharpenDbUpdate)

> For the complete documentation index, see [llms.txt](https://docs.tandemcx.ai/llms.txt). Any page on this site can be fetched as Markdown by appending `.md` to its URL.

Run an UPDATE query on a table in SharpenDB.

Modifies existing rows in a SharpenDB table. Set the fields and new values to write — values can use `$(name)` variables — and restrict which rows change with `Where` conditions. An update is refused, and takes `invalidInput` with the reason, when it has no condition, when a condition's value is blank (IS NULL, IS NOT NULL, IS TRUE, and IS NOT TRUE need none), or when a condition matches every row: a LIKE pattern of only `%`, or a NOT IN list holding an empty value. The flow takes `default` when the update succeeds. A query SharpenDB does not answer within 20 seconds takes `timeout`, or `fallback` when `timeout` is not wired. The node's Timeout field is not applied: it does not change that 20-second limit.

**Category:** Data  
**Provider:** Sharpen  
**Requires integration:** sharpen  
**Latest version:** 1.0.0

## Fields

| Field | Type | Required | Description |
| --- | --- | --- | --- |
| Table (`table`) | dynamicDropdown | Yes | The table to update. |
| Update fields (`fields`) | dynamic array of fields with options | Yes | Set fields to update with values |
| Where (`where`) | dynamic array of fields with options | Yes | WHERE conditions to filter which rows to update. Each condition compares a table field using an operator against a value. |
| Where Operator (`whereConditionOperator`) | string | No | What operator (AND/OR) to use for the where condition. |
| Variables (`variables`) | array of objects | No | Save variables from the data returned. |
| Timeout (`timeout`) | number | No | Not applied yet: SharpenDB queries always wait up to 20 seconds, whatever this is set to. |

## Exits

- `default` (required)
- `timeout` (required)
- `invalidInput` (system)
- `fallback` (system)

System exits (auto-injected, hidden when unwired): `invalidInput`, `fallback`.