Neo4j-csv批量导入

265 阅读1分钟
批量股票信息

LOAD CSV WITH HEADERS FROM 'file:///Stocks.csv' AS line 
CREATE(:Stock{stock_code:line.stock_code,chinesename:line.chinesename,id:line.id})

批量证券交易所信息

LOAD CSV WITH HEADERS FROM 'file:///exchange.csv' AS line 
CREATE(:Exchange{name:line.name,chinesename:line.chinesename,id:line.id})

批量创建关系信息
LOAD CSV WITH HEADERS FROM 'file:///stocks_exchange.csv' AS line 
MATCH (form:Stock{stock_code:line.stock_code}), (to:Exchange{id:line.exchange_id})
MERGE (form)-[r:交易所]—>(to)