neo4j的cypher语法

创建节点

CREATE(emp:Employee{id:123,name:"Lokesh",sal:35000})

查找

Match (n:Employee) return n 查所有数据

Match (n:Employee) return n.deptno 查编号

创建链接

CREATE (p1:Profile1)-[r1:LIKES]->(p2:Profile2)

条件查询

MATCH (n:Employee) WHERE n.id=123 return n

删除关系

MATCH(n1:Person{name:'Sally'})-[r:FRIENDS]-(n2:Person{name:'Steve'}) DELETE r

删除Employee

MATCH (n:Employee) DELETE n

删除Employee中id为123的节点

MATCH (n:Employee{id:123}) DELETE n

去掉Employee中id为123节点pd的属性

match(n: Employee {id:123}) remove n.pd return n

增加Employee中id为123的pd属性为786

MATCH (n:Employee) where n.id=123 set n.pd=786 RETURN n

排序（默认升序，desc降序）

MATCH (n:Employee) RETURN n.id,n.name,n.sal order by n.id

连接Employee和Department节点

match(n1:Employee) return n1.id as id,n1.pc as pc union match (n2:Department) return n2.id as id,n2.pc as pc

极限跳转

MATCH (n:Employee) RETURN n.id,n.pd,n.name,n.pc,n.sal limit 1（限制显示）

MATCH (n:Employee) RETURN n.id,n.pd,n.name,n.pc,n.sal skip 1（跳跃显示）

合并节点（有则检索，无则新增）

merge(n:Employee{id:125,name:"azqws"})

upper 大写

MATCH (e:Employee)RETURN e.id,UPPER(e.name),e.sal

lower 小写

MATCH (e:Employee)RETURN e.id,LOWER(e.name)

substring 打印前2个字符

MATCH (e:Employee)RETURN e.id,SUBSTRING(e.name,0,2)

计数

MATCH (e:Employee) RETURN COUNT(*)

最大，最小

MATCH (e:Employee) 

RETURN MAX(e.sal),MIN(e.sal)

增加唯一索引

CREATE CONSTRAINT ON (cc:CreditCard) ASSERT cc.number IS UNIQUE

去掉唯一索引

DROP CONSTRAINT ON (cc:CreditCard) ASSERT cc.number IS UNIQUE