The SET clause is used to update labels and properties on vertices and edges

Terminal SET clauses

A SET clause that is not followed by another clause is a terminal clause. When a cypher query ends with a terminal clause, no results will be returned from the cypher function call. However, the cypher function call still requires a column list definition. When cypher ends with a terminal node, define a single value in the column list definition: no data will be returned in this variable.

Set a property

To set a property on a node or relationship, use SET.

Query

SELECT * 
FROM cypher('graph_name', $$
   MATCH (v {name: 'Andres'})
   SET v.surname = 'Taylor'
$$) as (v agtype);

The newly changed node is returned by the query.

Result

Return created vertex

Creating a single vertex is done with the following query:

Query

SELECT * 
FROM cypher('graph_name', $$
    MATCH (v {name: 'Andres'})
    SET v.surname = 'Taylor'
    RETURN v
$$) as (v agtype);

The newly changed vertex is returned by the query.

Result

Remove a property

Normally a property can be removed by using REMOVE, but users can also remove properties using the SET command. One example is if the property comes from a parameter.

Query

SELECT * 
FROM cypher('graph_name', $$
    MATCH (v {name: 'Andres'})
    SET v.name = NULL
    RETURN v
$$) as (v agtype);

The node is returned by the query, and the name property is now missing.

Result

Set multiple properties using one SET clause

If you want to set multiple properties in one query, you can separate them with a comma.

Query

SELECT * 
FROM cypher('graph_name', $$
MATCH (v {name: 'Andres'})
SET v.position = 'Developer', v.surname = 'Taylor'
RETURN v
$$) as (v agtype);

Result