Actualización y eliminación de datos del grafo

In this lesson, you'll learn how to update and delete existing nodes and relationships in your Neo4j graph using Cypher. Modifying data is crucial for keeping your graph accurate and up-to-date.

We'll cover the essential clauses: SET for changing properties, REMOVE for taking properties or labels away, and DELETE / DETACH DELETE for removing graph elements entirely.

The SET clause is used to modify existing properties on nodes or relationships, or to add new ones. Let's start by updating a node's property.

This example first creates a 'Person' node, then updates their age.

Just like nodes, relationships can also have properties. You can use SET to update these properties too. First, we create a relationship, then we update one of its properties.

If you use SET with a property name that doesn't exist on a node or relationship, Cypher will simply add that new property. This is a handy way to extend your data model on the fly.

Sometimes you need to get rid of a property entirely. The REMOVE clause is designed for this. It can delete one or more properties from a node or a relationship.

Remember, REMOVE is for properties and labels, not for deleting entire nodes or relationships.

The REMOVE clause isn't just for properties; you can also use it to remove labels from a node. This can change the node's type or classification within your graph.

After removing the 'Person' label, the node still exists but is now just a generic node without that specific type.

To remove a relationship, you use the DELETE clause. You must first MATCH the relationship you want to delete and then pass its variable to DELETE.

Note: DELETE can only remove relationships or nodes that have no relationships.

What if you want to delete a node that has relationships connected to it? A simple DELETE won't work and will give an error.

The solution is DETACH DELETE. This powerful clause deletes the node and all its incoming and outgoing relationships in one go.

Deleting data is permanent! Always exercise caution:

• Test first: Run your MATCH clause with a RETURN to ensure you're selecting the correct elements before adding DELETE or DETACH DELETE.
• Backup: For critical data, ensure you have backups.
• Transaction awareness: In applications, deletions are often part of larger transactions.

You have a (:Movie {title: 'Inception'}) node that is connected to many (:Actor) nodes via [:ACTED_IN] relationships. You want to remove the 'Inception' movie node and all its connections.

Great job! You've mastered the core Cypher clauses for modifying and deleting graph data:

• SET: Updates existing properties or adds new ones to nodes and relationships.
• REMOVE: Deletes specific properties or labels from nodes and relationships.
• DELETE: Removes relationships or nodes that have no connections.
• DETACH DELETE: The safest way to delete a node and all its associated relationships in one go.

Always be careful when deleting data, and verify your MATCH patterns first!