创建
1、节点
CREATE (emp:Employee {name:"老唐",id:125,deptno:20,sal:55000} )
2、关系
MATCH (a:Employee),(b:Employee)
WHERE a.name = '老唐' AND b.name = '小刘666'
CREATE (a)-[r:上级{ name: a.name + '->' + b.name }]->(b)
RETURN type(r), r.name
3、单节点多标签
CREATE (m:Movie:Cinema:Film:Picture)
4、索引
CREATE INDEX ON :Employee(name)
5、唯一键
CREATE CONSTRAINT ON (emp:Employee)
ASSERT emp.id IS UNIQUE
删除
1、节点删除
MATCH (e: Employee) delete e
MATCH (e: Employee{id:124}) delete e
2、删除某个节点某个属性
MATCH (emp:Employee{ id:125})
REMOVE emp.sal
RETURN emp
3、删除唯一索引
DROP CONSTRAINT ON (emp:Employee)
ASSERT emp.number IS UNIQUE
修改
MATCH (emp:Employee{id:125})
SET emp.sal= '666666'
RETURN emp
基础查询(后续单开一篇查询)
MATCH (emp: Emplpyee)
RETURN emp.deptno,emp.name