> ## Documentation Index
> Fetch the complete documentation index at: https://docs.standardcomputers.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Updating Records in a Standard R1 Table by Constraint

> Update one or many records in a Standard table by specifying a constraint name, a new value, and an optional filter query with LIMIT.

Update records in Standard by appending the constraint name and new value to the table declaration. If you do not follow the constraint name and value with a filter query, all records in the table will have that constraint updated to the given value.

## Format

```text theme={null}
[std_name] CONST_NAME NEW_CONST_VAL ?<FILTER_PARAMS...>
```

* **`CONST_NAME`** — the name of the constraint you want to update.
* **`NEW_CONST_VAL`** — the new value to assign to that constraint.
* **`?<FILTER_PARAMS...>`** — an optional filter query to target specific records. Supports the same conditions and `LIMIT` syntax used in [finding records](/records/finding).

## Example

Update the year to `1984` for up to 4 green vehicles:

```text theme={null}
[vehicles] year 1984 <color "Green", LIMIT 4>
```

<Tip>
  Always include a filter query and a `LIMIT` when updating records to avoid unintended mass updates across your entire table.
</Tip>