neo4j图数据库常用CQL

1、创建节点

CREATE (m4:mail_list { name:"李一",gender:"男",ethnic:"汉",cardid:123456789,domicile:"山西太原"})
CREATE (m4:mail_list {id:"1",name:"李二",gender:"女",ethnic:"回",cardid:958545545225554,domicile:"山西太原小店区"})

2、创建关系

match(p1:mail_list),(p2:mail_list)
where p1.name="李一" and p2.name = "李二"
create (p1) -[suspect:suspect{relation:"亲戚"}]-> (p2);

3、查询mail_list标签

MATCH (n:mail_list) RETURN n

4、分页查询

MATCH (n:mail_list) RETURN n SKIP 2  LIMIT 25

5、查询两个节点之间的最短关系

match a = allshortestPaths((n:mail_list{name:"李静"})-[*]-(m:mail_list{name:"吴高辉"})) return a

6、找出两个节点深度为2的所有关系

match (n:mail_list{name:"李静"})-[*]-(m:mail_list{name:"吴高辉"}) return (n)-[*2]-(m) as p

7、查询两个节点之间的所有关系

match a = (n:mail_list{name:"李静"})-[*]-(m:mail_list{name:"吴高辉"}) return a

8、查询指定节点的所有关系

match a = (n:mail_list)-[]-() where n.name =~".*李.*" return a

9、删除标签及所有关系

MATCH (n:mail_list)-[r]-() DELETE n,r