【Neo4j】Neo4j的基本操作

neo4j语法总爱忘记，记点小笔记

1、导入csv文件（要导入的文件必须放在neo4j的import文件夹里面）

LOAD CSV WITH HEADERS FROM “file:///食品饮料331.csv” AS line MERGE
(a:展示行业测试{name:line.subject})merge(b:展示行业测试{name:line.object})merge(a)-[r:rs{rel:line.relation}]->(b)

2、节点名字错了，修改节点名字并关联节点

• 修改节点属性

match(n:展示行业测试{name:‘海水捕捞虾蟹类’}) set n.name = ‘海洋捕捞虾蟹类’

• 删除绑定错的节点

match(n:展示行业测试{name:‘海水捕捞虾蟹类’})<-[r]-(b) where id(n) = 88952 delete n,r

• 关联节点

MERGE
(a:展示行业测试{name:‘海洋捕捞’})merge(b:展示行业测试{name:‘海洋捕捞虾蟹类’})merge(a)-[r:rs{rel:‘下位产品’}]->(b)

3、查询一个节点的两层指向他的节点关系数据

match(a:展示行业测试{name : ‘羊皮’})<-[r*0…2]-(b:展示行业测试) where all(rel in r
where rel.rel = ‘下游’) with collect(b.name) as allNodes
match(c:展示行业测试)<-[rr]-(d:展示行业测试) where rr.rel = ‘下游’ and any(node in
allNodes where node = c.name) and any(node in allNodes where node =
d.name) return c.name,rr.rel,d.name

4、查询一个节点的最下位节点，不包含下游关系

match(n:展示行业测试{name:‘果蔬菌菇’})-[r:rs*0…]->(b) where all(rel in r where
rel.rel <> ‘下游’) and NOT (b)-[:rs]->() return b.name

5、创建索引

CREATE INDEX ON :label_name (property_name)
create index on :展示行业测试 (level)

6、匹配一个集合的所有内容

match(n:展示行业测试)<-[r:rs*]-(b:展示行业测试) where b.level=‘1’ and all(rel in r
where rel.rel <> ‘下游’) and n.name in[‘红薯’,‘木薯’] return n.name as
keyName,b.name as valueName

7、路径操作

match p = (a:展示行业测试{name : ‘白酒’})<-[r*0…2]-(b:展示行业测试) where all(rel
in r where rel.rel = ‘下游’) return p

8、导入文件时查找为null数据

LOAD CSV WITH HEADERS FROM “file:///testNSCGY5.26.csv” AS line WITH
line WHERE line.object is null RETURN line