Set

Database

SET

SET is similar to that in SQL. It allows updating properties of node or relationship records (possibly NULL).

We will use the example database for demonstration, whose schema and data import commands are given here.

Set Node Properties

Set Single Label Node Properties

The following query sets the age property of the User node with name Adam to 50 (which is 30 in the original database).

MATCH (u:User)
WHERE u.name = 'Adam'
SET u.age = 50
RETURN u.*;

┌────────┬───────┐
│ u.name │ u.age │
│ STRING │ INT64 │
├────────┼───────┤
│ Adam   │ 50    │
└────────┴───────┘

Similarly the following sets Adam’s age property to NULL. Query:

MATCH (u:User)
WHERE u.name = 'Adam'
SET u.age = NULL
RETURN u.*;

┌────────┬───────┐
│ u.name │ u.age │
│ STRING │ INT64 │
├────────┼───────┤
│ Adam   │       │
└────────┴───────┘

Set Multi Label Node Properties

Kùzu also supports updating node properties with multi-label nodes.

MATCH (u)
SET u.population = 0
RETURN label(u), u.name, u.population;

┌──────────────────────────┬───────────┬──────────────┐
│ LABEL(u._ID,[User,City]) │ u.name    │ u.population │
│ STRING                   │ STRING    │ INT64        │
├──────────────────────────┼───────────┼──────────────┤
│ City                     │ Waterloo  │ 0            │
│ City                     │ Kitchener │ 0            │
│ City                     │ Guelph    │ 0            │
│ User                     │ Adam      │              │
│ User                     │ Karissa   │              │
│ User                     │ Zhang     │              │
│ User                     │ Noura     │              │
│ User                     │ Bob       │              │
│ User                     │ Alice     │              │
│ User                     │ Dimitri   │              │
└──────────────────────────┴───────────┴──────────────┘

Note that node tabel “User” doesn’t contain the “population” property, thus tuples belonging to “User” table are ignored (reamining as NULLs) during Set operations.

Set Relationship Properties

Set Single Label Relationship Properties

The following query sets the since property of the Follows relationship(From Adam to Karissa) to 2012 (which is 2020 in the original database).

MATCH (u0:User)-[f:Follows]->(u1:User)
WHERE u0.name = 'Adam' AND u1.name = 'Karissa'
SET f.since = 2012
RETURN f;

┌───────────────────────────────────────────────────────┐
│ f                                                     │
│ REL                                                   │
├───────────────────────────────────────────────────────┤
│ (0:0)-{_LABEL: Follows, _ID: 2:0, since: 2012}->(0:1) │
└───────────────────────────────────────────────────────┘

Set Multi Label Relationship Properties

MATCH (u0)-[f]->()
WHERE u0.name = 'Adam'
SET f.since = 1999
RETURN f;

┌───────────────────────────────────────────────────────┐
│ f                                                     │
│ REL                                                   │
├───────────────────────────────────────────────────────┤
│ (0:0)-{_LABEL: Follows, _ID: 2:0, since: 1999}->(0:1) │
│ (0:0)-{_LABEL: Follows, _ID: 2:1, since: 1999}->(0:2) │
│ (0:0)-{_LABEL: Follows, _ID: 2:4, since: 1999}->(0:3) │
│ (0:0)-{_LABEL: LivesIn, _ID: 3:0}->(1:0)              │
└───────────────────────────────────────────────────────┘