neo4j常用cypher查询语句

删除所有孤立节点

MATCH (n) WHERE NOT (n)--() DELETE n

合并创建

MERGE (s:员工 {name: '张三'}) ON CREATE set s.name='张三', s.age=23 ON MATCH set s.name='张三',s.age=23 
MERGE (s:员工 {name: '李四'}) ON CREATE set s.name='李四', s.age=23 ON MATCH set s.name='李四',s.age=24 
MERGE (s)-[r:同事 {time:datetime('2020-7-6')}]->(e) ON CREATE set r.name='xxx' ON MATCH set r.name='xxx' 
RETURN s,e,r

多标签查询

MATCH (n) WHERE any(label in labels(n) WHERE label in ['公司', '员工']) RETURN n

模糊查询

MATCH (n) WHERE n.name=~'.*张.*'

删除节点和关系

MATCH (n) WHERE id(n)=14539 DETACH DELETE n

统计节点个数

MATCH (n) RETURN DISTINCT count(n)

统计节点标签

MATCH (n) RETURN DISTINCT labels(n)

统计关系类别

MATCH ()-[r]-() RETURN DISTINCT type(r)