1、创建节点和标签
CREATE (emp:Employee)
CREATE (dept:Dept)
2、创建具有属性的节点
CREATE (dept:Dept { deptno:10,dname:"Accounting",location:"Hyderabad" })
CREATE (emp1:Person { name:"test1",title:"Accounting",age:20 })
3、查询部分属性
MATCH (emp1:Person)
WHERE emp1.name = 'Vic'
RETURN emp1.name,emp1.title,emp1.age
4、查询所有属性
MATCH (emp1:Person)
RETURN emp1
CREATE (e:Customer{id:"1001",name:"Abc",dob:"01/10/1982"})
CREATE (cc:CreditCard{id:"5001",number:"1234567890",cvv:"888",expiredate:"20/17"})
5、创建节点的关系
MATCH (cust:Person),(cc:Person)
WHERE cust.name = "Andres" AND cc.name= "Vic"
CREATE (cust)-[r:Friend{shopdate:"12/12/2014",price:55000}]->(cc)
RETURN r
6、删除节点
MATCH (emp1:Person)
WHERE emp1.name = 'test1'
delete emp1
删除节点关联关系
MATCH (cc:Person)-[r]-(c:Person)
WHERE cc.name ='Vic' AND c.name= 'Andres'
DELETE r
7、删除属性REMOVE
CREATE (per:Person {name:"per",title:"Neo4j Tutorial",age:25})
MATCH (per { name:"per" })
REMOVE per.age
删除标签
MATCH (m:PERSON) REMOVE m:PERSON
RETURN per
8、向现有节点添加新属性
MATCH (dc:Employee)
SET dc.name = "zhangsan"
RETURN dc
修改属性值
MATCH (dc:Employee)
WHERE dc.name = "zhangsan"
SET dc.name = "zhangsan1"
RETURN dc
9、按照属性值排序
MATCH (dc:Employee)
RETURN dc.name, dc.age
ORDER BY dc.age desc
10、UNION和UNION的用法
MATCH(per:Person)
RETURN per.name as name,per.age as age
UNION ALL
MATCH(emp:Employee)
RETURN emp.name as name, emp.age as age
11、LIMIT的用法（前两行）
MATCH (emp:Employee)
RETURN emp
ORDER BY emp.age
LIMIT 2
SKIP的用法（后两行）
MATCH (emp:Employee)
RETURN emp
ORDER BY emp.age
SKIP 2
12、合并创建节点、关系和属性
MERGE (emp:Employee{ age: 25,Name:"zhangsan"})
CREATE (gp1:GoogleProfile1 {Id: 201401, Name:"Apple"})
CREATE (gp1:GoogleProfile1 {Id: 201401, Name:"Apple"})
MERGE (gp2:GoogleProfile2{ Id: 201402,Name:"Nokia"})
MERGE (gp2:GoogleProfile2{ Id: 201402,Name:"Nokia"})
13、IN运算符，用[]
14、图形字体
MATCH (cc: Person)-[r]-()
WHERE cc.name="Vic"
RETURN r
15、函数
UPPER(e.name)
LOWER(e.name)
SUBSTRING(e.name,0,2)
聚合函数
MATCH (e:Employee) RETURN COUNT(*)
MATCH (e:Employee) RETURN MAX(e.sal),MIN(e.sal)
MATCH (e:Employee) RETURN SUM(e.sal),AVG(e.sal)
16、关系函数
关系开始节点：
MATCH (a)-[movie:Friend]->(b)
RETURN STARTNODE(movie)
关系结束节点：
MATCH (a)-[movie:Friend]->(b)
RETURN ENDNODE(movie)
关系ID和关系类
MATCH (a)-[movie:ACTION_MOVIES]->(b)
RETURN ID(movie),TYPE(movie)
17、创建和删除索引
CREATE INDEX ON :Customer (name)
DROP INDEX ON :Customer (name)
18、创建和删除唯一约束
CREATE CONSTRAINT ON (cc:CreditCard)
ASSERT cc.number IS UNIQUE
DROP CONSTRAINT ON (cc:CreditCard)
ASSERT cc.number IS UNIQUE