Skip to main content

Cypher clauses overview

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

  • CREATE - creates new nodes and edges;
  • DELETE - deletes nodes and edges;
  • 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;
  • REMOVE - removes labels and properties;
  • RETURN, for defining what will be presented to the user in the result set;
  • SET, for adding new or updating existing labels and properties;
  • UNION and UNION ALL for combining results from multiple queries;
  • [UNWIND], for unwinding a list of values as individual rows
  • WHERE, for filtering the matched data;
  • WITH, for combining multiple reads and writes.