cypher命令创建图简单测试

创建的图

 

 a friend of a friend

 

ppt   test0

 

 

 

语句

-- 清空
match (n1)-[r1]-(n2) delete n1,n2,r1;
--查
match (n1)-[r1]->(n2) RETURN  n1,r1,n2;


MATCH (a:label1),(m:label2) OPTIONAL 
MATCH (a)-[r1]-(), (m)-[r2]-() DELETE a,r1,m,r2;

CREATE (n:Person{ name: 'lzl',bornYear: 1974});
match (n) return n;
match (n:Person) where n.name='lzl' return n;
match(n{name:'lzl'}) return n;
match(n) where n.born<1999 return n;

--导入
LOAD csv FROM 'http://we-yun.com/neo4jguide/movie.csv' AS line
CREATE (:Movie{title:line[0],relased:line[1],tagline:line[2]})
RETURN line;

-- a friend of a friend
CREATE (wei:student:male{name:'wwl'}),
       (jin:student:male{name:'jj'}),
	   (liu:student:male{name:'xld'}),
	   (wei)-[:Friend{time:'2014-9'}]->(jin),
	   (jin)-[:Friend{time:'2014-9'}]->(liu);
match (wei:student{name:'wwl'})-[:Friend]->()-[:Friend]->(fof)
RETURN fof.name AS fofname;
-- ppt KNOWS
create (a:Person{name:'jim'})-[:KNOWS]->
          (b:Person{name:'lan'})-[:KNOWS]->
          (c:Person{name:'Emil'}),
          (a)-[:KNOWS]->(c);
--===================ppt test0=======================
CREATE (:Person{name:'lan'})-[:EMPLOYMENT]->
       (job:Job{start:'2011-01-05'})-[:EMPLOYER]->
       (:Company{name:'Neo'}),
       (job)-[:ROLE]->(:Role{name:'engineer'});

MATCH (p:Person),(j:Job),(r:Role),(c:Company) OPTIONAL 
MATCH (p)-[r1]-(), (j)-[r2]-(), (r)-[r3]-(),(c)-[r4]-()  
DELETE r1,r2,r3,r4,p,j,r,c;
--===================ppt test1=========================
CREATE (:Actor{name:'William Hartnell'})-[:PERFORMED_IN]->
	   (performance:Performance{year:1964})-[:FOR]->
	   (:Story{title:'The Sensorties'}),
       (performance)-[:PLAYED]->(:Role{name:'The Doctor'});

--====================ppt test2==========================
CREATE (:Person:man{name:'Lan'})-[:SENT]->
	   (email:Email{content:'...'})-[:TO]->
	   (:Person{name:'Jim'}),
	   (email)-[:CC]->(:Person{name:'Alistair'});



--====================ppt test3==========================
CREATE (:Person {name: 'Alistair'})-[:WROTE]->
	   (review :Review {test: '…'})-[:OF]->
	   (:Film{title: '…'}),
	   (review)- [:PUBLISHED_IN]->
	   (:Publishion{title: '…'};

 

 

-- 清空
match (n1)-[r1]-(n2) delete n1,n2,r1;
--查
match (n1)-[r1]->(n2) RETURN  n1,r1,n2;

CREATE (a:Person{name:'aa',age:18})-[:Friend]->
       (b:Person{name:'bb',age:19})-[:Friend]->
	   (c:Person{name:'cc',age:20}),
       (a)-[:Friend]->
	   (d:Person{name:'dd',age:21})-[:Friend]->
	   (e:Person{name:'ee',age:22});

match (a:Person)-[:Friend]->()-[:Friend]->(fof) 
WHERE a.age=18 
RETURN fof.name AS name;

match (a:Person)-[:Friend]->()-[:Friend]->(fof)
WHERE id(a)=23 
RETURN fof.name AS name;

CREATE (a:Person{name:'aa'})-[:Friend]->
       (b:Person{name:'bb'})-[:Friend]->
	   (c:Person{name:'cc'}),
       (b)-[:Friend]->
	   (d:Person{name:'dd'})

--MERGE
MERGE  (a:Person:male {name: 'wwl'});
MERGE (b:female:teacher {name: 'dxf'});

MATCH (a:Person {name: 'wwl'}),(b:female{name: 'dxf'})
MERGE (a)-[:KNOWS]->(b);

MERGE (n:student{name: 'wwl'})
ON CREATE SET n.created = timestamp();

Match (a {name: 'wwl'}),(c {name: 'dxf'})
MERGE (a)-[:Friend{rels:3}]->(c);

MERGE (wei1:Person {name:'wei1'})
ON CREATE SET wei1.created=timestamp()          --不存在则创建
ON match SET wei1.lastSeen=timestamp()          --存在则创建
RETURN wei1.name,wei1.created,wei1.lastSeen;

--SET

UNWIND [{age:30},{addr: 'bj'}] AS prop
MERGE (n:Person {name: 'a'})
SET n += prop;

MERGE (n:Person {name: 'a'})
SET n.created = timestamp();

MERGE (n:female:teacher {name: 'dxf'})
SET n:Person;

--remove
MATCH (n) REMOVE n:Person;
MATCH (a {name: 'a'}) REMOVE a.name;

--where
CREATE (n:Person{ name: 'foo',bornYear: 1974}), (m:Person{ name: 'son',bornYear: 1999});
match (n)  where n.bornYear>1998 and not n.name='foo'  return (n);      -- son 
match (n)  where n.bornYear>1998 or not n.name='foo'  return (n);        --  son
match (n)  where n.bornYear>1998 xor n.name='so1n'  return (n);               -- son

--foreach
WITH ['a','b','c'] AS col FOREACH (value IN col | CREATE (:Person {name:value}));

--delete
match (n) detach delete n;