Clauses

Clauses

The Cypher language enables users to perform standard database operations by using the following clauses:

  • CALL - calls a subquery inside the query
  • CASE - allows the creation of conditional expressions
  • CREATE - creates new nodes and relationships
  • DELETE - deletes nodes and relationships
  • EXPLAIN - inspect a particular Cypher query in order to see its execution plan.
  • FOREACH - iterates over a list of elements and stores each element inside a variable
  • LOAD CSV - loads data from CSV file
  • MATCH - searches for patterns
  • MERGE - creates patterns if they don't exist
  • OPTIONAL MATCH - behaves the same as MATCH, but when it fails to find the pattern it fills missing parts of the pattern with null values
  • PROFILE - profiles the execution of a query returns a detailed report on how the query's plan behaved
  • REMOVE - removes labels and properties
  • RETURN - defines what will be presented to the user in the result set
  • SET - adds new or updates existing labels and properties
  • UNION and UNION ALL - combines results from multiple queries
  • UNWIND - unwinds a list of values as individual rows
  • WHERE - filters the matched data
  • WITH - combines multiple reads and writes