Skip to main content
The SET clause is used to update property values on existing nodes and edges. It is always used in combination with a MATCH clause that identifies the entities to update. 
// Update a single property
MATCH (n:Person {name: 'Alice'})
SET n.age = 30

// Commit the changes
COMMIT

​
Setting a single property

To update a property on a node or edge, use SET followed by a property assignment.
MATCH (n:Person {name: 'Alice'})
SET n.age = 30
This sets the age property of the matched node to 30. If the property does not already exist, it will be created.

​
Setting multiple properties

Multiple properties can be updated in a single SET clause by separating assignments with commas.
MATCH (n:Person {name: 'Alice'})
SET n.position = 'Developer', n.surname = 'Taylor'

​
Setting a property from an expression

The value assigned can be any expression, including arithmetic operations on existing properties.
MATCH (p:Product)
SET p.discountPrice = p.price * (1 - 0.15)

​
Setting a property from another variable

You can copy a property value from one matched entity to another.
MATCH (n:Person {name: 'Alice'}), (m:Person {name: 'Bob'})
SET n.age = m.age

​
Updating edge properties

Edge properties can be updated using the same syntax.
MATCH (n:Person {name: 'Alice'})-[e:KNOWS]->(m:Person {name: 'Bob'})
SET e.since = 2020

​
Updating a specific node by internal ID

Every node in TuringDB has an internal ID. You can target a specific node by comparing it directly to its ID in a WHERE clause. This is useful when you already know the exact node you want to update.
MATCH (n)
WHERE n = 1234
SET n.age = 42

​
Using SET with WHERE

SET can be combined with WHERE to update properties on nodes that match a condition.
MATCH (n:Person)
WHERE n.age < 18
SET n.isMinor = true
CREATE ... SET is not supported. When creating nodes or edges, use brace initialisation to set properties directly in the CREATE clause:
CREATE (:Person {name: 'Alice', age: 30})