控制台进入neo4j
neo4j.bat console
删除所有记录
match (n) detach delete n
如何去除Property Keys–删库
暂停服务;
/data/databases路径下,删除 graph.db 目录【命令为:rm -rf graph.db】;
重启服务。
去掉uri前缀
match(n) where n.uri=~“http://www.semanticweb.org/qiangzhang/ontologies/2022/1/untitled-ontology-6#.*” set n.uri=substring(n.uri,70) return n
导入CSV文件 (文件提前保存在import文件夹内)
品牌
LOAD CSV WITH HEADERS FROM "file:///bank.csv"AS line
CREATE (:Bank {name:line.bank,count:line.count})
车型
LOAD CSV WITH HEADERS FROM "file:///serise.csv"AS line
CREATE (:serise {name:line.serise,count:line.count})
/创建品牌和车型之间的关系
LOAD CSV WITH HEADERS FROM "file:///serise.csv"AS line
MATCH (entity1:Bank {name:line.bank })(entity2:Serise {name:line.serise})
CREATE (entity1)-[:Subtype type:line.relation ->(entity2)
建立约束
CREAT CONSTRAINT ON (b:Bank)
ASSERT b.name IS UNIQUE