# Updating rows

UPDATE changes matching rows immediately; an upsert combines insertion with a conflict-driven update. Both validate target types and constraints and follow transaction rules.

Read [Update data](https://coordinatordb.com/docs/concepts/features/operations/update/overview) for a worked example and the links to the exact statement syntax.