开放原子开发者工作坊

10-100-22-94:/data/soft/neo4j-community-not/import

student.csv：

organization.csv：

 

relation.csv：

 

#导入student表 

LOAD CSV WITH HEADERS FROM "file:///student.csv" as line

with line where line.id is not null
MERGE (s:Student{id:toInteger(line.id),name:line.name})

#导入organization表
LOAD CSV WITH HEADERS FROM "file:///organization.csv" as line
MERGE (s:Organization{id:toInteger(line.id),name:line.name})

 

#导入关系表relation

LOAD CSV WITH HEADERS FROM "file:///relation.csv" as line
match (from:Student{id:toInteger(line.mid)}),(to:Organization{id:toInteger(line.gid)})
merge(from)-[r:friends{start_id:toInteger(line.mid),end_id:toInteger(line.gid),re:toString(line.links)}]->(to)