CQL Introduction

CQL (Cypher Query Language) is the dedicated query language for Neo4j graph database.

CREATE Command

Basic Syntax Structure

CREATE (<node-name>:<label-name>[{
  <property1-name>:<property1-Value>
}])

Usage Examples

  1. Create a simple node:
CREATE (:Person)
  1. Create a node with properties:
CREATE (:Person {name:'Bob', age:30, email:'bob@example.com'})
  1. Create a node with multiple labels:
CREATE (:Person:Employee {emp_id:'E1001'})

Data Creation Examples

CREATE (person:Person {cid:1,name:"wzk1",age:24,gender:0,character:"A",money:1000});
CREATE (person:Person {cid:2,name:"wzk2",age:20,gender:1,character:"B",money:800});
CREATE (person:Person {cid:3,name:"wzk3",age:18,gender:0,character:"A",money:500});

MATCH RETURN

Examples

MATCH (person:Person) return person
MATCH (person:Person) return person.name, person.age

Relationship Creation

Create relationships without properties using existing nodes

match(person:Person {name:"wzk1"}) ,(person2:Person {name:"wzk2"})
create(person)-[r:Couple]->(person2);

Query relationships

match p = (person:Person {name:"wzk1"})-[r:Couple]->(person2:Person) return p;
match (p1:Person {name:"wzk1"})-[r:Couple]-(p2:Person) return p1,p2;

Create relationships with properties using existing nodes

match(person:Person {name:"wzk1"}),(person2:Person {name:"wzk2"})
create(person)-[r:Couple{marry_date:"11/11/2025",price:55000}]->(person2)
return r;