Skip to content

Update basics — AQL

update User
filter .id = $id
set {
name := $name,
active := $active
};
-- $1: name
-- $2: active
-- $3: id
UPDATE "user" u SET
name = $1,
active = $2
WHERE u.id = $3
RETURNING *;

To leave columns unchanged when a value is absent, see Partial updates.