DPS-Prac2

Practical 2

CREATE (:Person {name: 'Alice', age: 25})

MATCH (p:Person) RETURN p

MATCH (a:Person {name: 'Alice'}), (b:Person {name: 'Bob'})
CREATE (a)-[:FRIENDS_WITH {since:2021}]->(b)

MATCH (a:Person {name: 'Alice'}), (b:Person {name: 'Bob'})
MATCH a-[r]->b RETURN r;

MATCH ()-[r]->() RETURN r;

MATCH (a:Person), (b:Person)
MATCH a-[r]->b RETURN a,r,b;

MATCH (a)-[r]->(b) RETURN a, r, b;

MATCH (p:Person) WHERE p.city = 'Delhi' RETURN p

MATCH (p:Person) RETURN p.name, p.age

MATCH (p:Person {name: 'Alice'}) SET p.age = 26

MATCH (p:Person) SET p.email = toLower(p.name) + '@example.com'

MATCH (p:Person {name:'Charlie'}) DETACH DELETE p

MATCH (a:Person {name:'Bob'})-[r:FRIENDS_WITH]->(c:Person
{name:'Charlie'}) DELETE r

MATCH (p:Person)
OPTIONAL MATCH (p)-[:FRIENDS_WITH]->(f)
RETURN p, f

MATCH (p:Person) RETURN count(p)

MATCH (p:Person)-[:FRIENDS_WITH]->(f)
RETURN p.name, collect(f.name) AS friends


MATCH (a:Person {name:'Alice'}), (b:Person {name:'David'})
MATCH path = shortestPath((a)-[*]-(b))
RETURN path

MATCH (a:Person {name:'Alice'})-[:FRIENDS_WITH*1..2]->(b) RETURN b