提示:Neo4j版本为3.4.10 java8
4.0版本后jdk需要java11
一、安装
1.下载地址:http://neo4j.com/download/
2.下载ZIP包并解压
3.打开CMD到解压后的bin目录,输入
neo4j.bat console
4.打开浏览器请求:http://localhost:7474/
默认端口为7474,可以去conf/neo4j.conf下修改,默认账号密码为neo4j/neo4j
二、操作CSV
csv导入会重复导入
1.将csv文件放入/import目录下
2.输入命令导入
1).导入a.csv
load csv with headers from "file:///a.csv" as line with line create(:a{ spu:line.spu, order_cnt:line.order_cnt, sku_cnt:line.sku_cnt })
2).导入b.csv
load csv with headers from "file:///b.csv" as line with line create(:b{ spu3:line.spu3, spu:line.spu, order_cnt:line.order_cnt, sku_cnt:line.sku_cnt })
3).建立ab关系
LOAD CSV WITH HEADERS FROM "file:///b.csv" AS row
MATCH (a1:a {spu: row.spu})
MATCH (b1:b {spu3: row.spu3})
MERGE (a1)-[:ab]->(b1);
3.查询
1).查询关联关系
//无条件
MATCH p=()-[r:ab]->() RETURN p
//条件
MATCH p=()-[r:ab]->(b1:b{spu:"xxx"}) RETURN p
2).查询单独Lables
MATCH (n:a) RETURN n
3.删除
//删除全部关系
MATCH p=()-[r:ab]->() delete p
//删除单个Lable
MATCH (n:a) delete n