Neo4j
一笆制、創(chuàng)建節(jié)點
create (Kungfu:Move {title:'Kungfo', released:2008, tagline:'made in china'})
二仪糖、創(chuàng)建人物節(jié)點
create (Zhouxingchi:Person {name:'zhouixingchi', born:1980})
三揖盘、創(chuàng)建演員導(dǎo)演關(guān)系
create (Zhouxingchi)-[:acted_in {role:'self'}]->(Kungfo)
,
create (Zhouxingchi)-[:directed]->(Kungfo)
四、查找節(jié)點
1.按名字查找:
match (xingye {name:'zhouxingchi'}) return xingye
2.查找電影
match (kf {title:'Kungfo'}) return kf
3.隨機(jī)查找多個人物
match (people:Person) return people.name limit 10
4.查找多個電影
match (mv:Movie) where mv.released >1970 and mv.released < 2000 return mv.title
五等龙、查找關(guān)系
1.查找演員參演過的電影
match (xingye:Person {name:'zhouxingchi'})-[:acted_in]->(xingMovie) return xingye, xingMovie
2.查看誰導(dǎo)演了電影
match (dianying {title:'Kungfo'})<-[:directed]-(daoyan) return daoyan.name
3.查看與zhouxingchi同出演過電影的人
match (xingye:Person {name:'zhouxingchi'})-[:acted_in]->[m]<-[:acted_in]-(yanyuan) return yanyuan.name
4.查找與kungfo相關(guān)的所有人(人名、電影關(guān)系類型、電影的關(guān)系)
match (people:Person)-[relatedTo]-(:Movie {title:'kungfo'}) return people.name, Type(relatedTo), relatedTo
六峭状、查詢關(guān)系路徑
1.查找與演員zhouxingchi存在4條及以內(nèi)的任何演員及電影
match (bacon:Person {name:'zhouxingchi'})-[*1..4]-(movies) return distinct movies
2.查找演員之間最短路線
match p=shortestPath( (bacon:Person {name:'zhouxingchi'})-[*]-(meg:Person {name:'zhuyin'}) ) return p
3.查找沒有與zhouxingchi合作過的演員
match (xingye:Person {name:'zhouxingchi'})-[:acted_in]->(m)<-[:acted_in]-(yanyuan), (yanyuan)-[:acted_in]->(m2)<-[acted_in]-(yanyuan2) where not xingye-[:acted_in]->(m2) return yanyuan2.name as unxingstar, count (*) as strength order by strength.desc
4.找人將zhouxingchi介紹給zhuyin
match (xingye:Person {name:'zhouxingchi'})-[:acted_in]->(m)<-[:acted_in]-(yanyuan), (yanyuan)-[:acted_in]->(m2)<-[acted_in]-(zixia:Person {name:'zhuyin'}) return xingye, m, yanyuan, zixia
七、清空數(shù)據(jù)庫
1.清空所有Person逼争、Movie節(jié)點
match (a:Person), (m:Movie) optional match (a)-[r1]-(), (m)-[r2]-() delete a, r1, m, r2
2.檢查任意數(shù)據(jù)
match (n) return n