Manipulating the Database | Learning Cypher

Deleting data

Cypher provides two clauses to delete data. They are as follows:

REMOVE: This clause is used to remove labels and properties from nodes or relationships
DELETE: This clause is used to delete nodes and relationships from the database

Removing labels

To remove a label from a node, you must use the REMOVE clause. The syntax is similar to the one for the SET clause, as shown in the following query:

MERGE (b:User {name: "Jack", surname: "Smith"})
REMOVE b:Inactive:MustConfirmEmail

This query removes the labels Inactive and MustConfirmEmail from the node that was matched. Note that we have chained the labels using the colon separator. If the node already doesn't have one or all of the labels specified, this query will not fail; it will only remove the labels it can remove.

Removing properties

The REMOVE clause is the opposite of the SET clause. It can be used to remove a property from a node, as shown in the following query:

MERGE (b:User {name: "Jack", surname: "Smith"})
REMOVE b.age

Anyway...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Learning Cypher

By : Onofrio Panzarino

Learning Cypher

By: Onofrio Panzarino

Overview of this book

Deleting data

Removing labels

Removing properties

Learning Cypher

By : Onofrio Panzarino

Learning Cypher

By: Onofrio Panzarino

Overview of this book

Deleting data

Removing labels

Removing properties

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access