Cypher SET: Updating Node Properties in Your Graph Database [Byte-Sized Cypher Series]
It’s Monday, and you know what that means: It’s time to learn some Cypher!
Byte-Sized Cypher is a beginner-friendly video series that teaches you the Cypher query language through short, practical examples and memorable snack-based metaphors. 🍡
In this series, DevRel legend and snack enthusiast Jason Koo breaks down the most important openCypher clauses into small, digestible episodes. openCypher is the open source version of the Cypher query language originally created by Neo4j, and is designed specifically for working with graph databases and highly connected data.
Just to clarify: Jason doesn’t work for gdotv, but we’re big fans of this video series, and with his permission, we’re sharing these videos with our blog readers. We hope this series helps you master the Cypher query language – or even just get comfortable with using it for the very first time!
In previous weeks, we covered the Cypher CREATE clause for adding data to your graph, took a closer look at using labels in Cypher, learned how to use the MATCH clause to find specific nodes and relationships, dove into the RETURN clause to manage query results, and explored how the DISTINCT clause removes duplicate results. This week, we’ll take a closer look at how the SET clause enables you to update node properties in Cypher queries.
The Cypher SET Clause: Updating Node Properties
In this episode, Jason teaches you the SET clause – which allows you to add, edit, and delete node properties in openCypher. He uses the delicious Japanese snack Warabi Mochi as a helpful guide throughout the demo to make these concepts stick (and to make you hungry).
In this video, you’ll learn about:
- Adding a property with SET
- Overwriting a property
- Setting multiple properties at once
- Deleting properties with null
- Adding Labels with SET
- The += operator: amend properties without replacing
- Copying properties between nodes
- Setting properties on relationships
- Using expressions with SET
- CASE statements with SET
Special note: In this video, Jason makes great use of the gdotv graph database IDE to help demonstrate Cypher queries and visualize the resulting graph data. No matter if you’re new to graphs or a seasoned vet, gdotv helps you do your best work with graph technology – but don’t just take our word for it: Try it out for yourself!
Looking to Dive Deeper into Cypher?
If you’re ready to level up your Cypher game, here’s a hands-on introduction written by the Neo4j team – complete with full documentation. Or need the full technical specification of the Cypher query language? Here’s the most current openCypher spec (version 9).
For handy reference, here are just a few of the most popular graph databases and graph query engines that use Cypher or an openCypher variant:
- Neo4j (including AuraDB)
- Memgraph
- FalkorDB
- Amazon Neptune & Neptune Analytics
- ArcadeDB
- Kuzu
- LadybugDB
- HugeGraph
- PuppyGraph
- And others
All of the above graph technologies are supported by gdotv to use for Cypher query writing, debugging, editing, profiling, and more.
See You at the Next Episode of Byte-Sized Cypher!
Hungry for more Cypher? Check out the full series playlist here as Jason is always adding more videos. If you enjoyed this video, subscribe to Jason Koo’s YouTube channel for more videos on graph technology and other great developer tools, platforms, and languages.
Need a break between snacks? Catch the next episode of Byte-Sized Cypher here on the gdotv blog every Monday. See you then!
Become the graph database developer you were always destined to be: Get gdotv today and boost your graph powers – from querying and editing to exploration and visualization.
