neo4j 导入

最新推荐文章于 2024-07-31 10:46:49 发布

Claroja

最新推荐文章于 2024-07-31 10:46:49 发布

阅读量232

点赞数

分类专栏：数据库文章标签：图数据库

本文链接：https://blog.youkuaiyun.com/claroja/article/details/84141569

版权

数据库专栏收录该内容

28 篇文章

订阅专栏

1,ABBA,1992
2,Roxette,1986
3,Europe,1979
4,The Cardigans,1992

1.导入csv

LOAD CSV FROM 'https://neo4j.com/docs/developer-manual/3.4/csv/artists.csv' AS line
CREATE (:Artist { name: line[1], year: toInteger(line[2])})

2.导入csv,包含头

Id,Name,Year
1,ABBA,1992
2,Roxette,1986
3,Europe,1979
4,The Cardigans,1992

LOAD CSV WITH HEADERS FROM 'https://neo4j.com/docs/developer-manual/3.4/csv/artists-with-headers.csv' AS line
CREATE (:Artist { name: line.Name, year: toInteger(line.Year)})

3.导入特殊格式csv

1;ABBA;1992
2;Roxette;1986
3;Europe;1979
4;The Cardigans;1992

LOAD CSV FROM 'https://neo4j.com/docs/developer-manual/3.4/csv/artists-fieldterminator.csv' AS line FIELDTERMINATOR ';'
CREATE (:Artist { name: line[1], year: toInteger(line[2])})

4.一行一行导入

USING PERIODIC COMMIT
LOAD CSV FROM 'https://neo4j.com/docs/developer-manual/3.4/csv/artists.csv' AS line
CREATE (:Artist { name: line[1], year: toInteger(line[2])})

5.Setting the rate of periodic commits

6.Import data containing escaped characters

参考文献:
https://neo4j.com/docs/developer-manual/3.4/cypher/clauses/load-csv/