ÖRNEK KODLAR
//DEPT TABLOSU
CREATE (n:DEPT {NO:10,DNAME: ‘ACCOUNTING’})
CREATE(n:DEPT {NO:20, DNAME: ‘RESEARCH’})
CREATE(n:DEPT {NO:30, DNAME: ‘SALES’})
CREATE(n:DEPT {NO:40, DNAME: ‘OPERATIONS’})
//EMP TABLOSU
CREATE (n:EMP { DEPTNO:10,EMPNO: ‘7902’, ENAME: ‘FORD’, JOB:’ANALYST’, MGR:7566, HIREDATE: 1981-12-03, SAL:3000 })
CREATE (n:EMP { DEPTNO:20,EMPNO: ‘7876’, ENAME: ‘ADAMS’, JOB:’CLERK’, MGR:7788, HIREDATE: 1983-01-12, SAL:1100})
CREATE (n:EMP { DEPTNO:30,EMPNO: ‘7934’, ENAME: ‘MILLER’, JOB:’LERK’, MGR:7782, HIREDATE: 1982-01-23, SAL:1300})
CREATE (n:EMP { DEPTNO:40,EMPNO: ‘7698’, ENAME: ‘BLAKE’, JOB:’MANAGER’, MGR:7839, HIREDATE: 1981-05-01, SAL:2850})
CREATE (n:EMP { DEPTNO:10,EMPNO: ‘7698’, ENAME: ‘JACK’, JOB:’MANAGER’, MGR:7839, HIREDATE: 1981-05-01, SAL:2850})
//İLİŞKİLENDİRME
MATCH (a:EMP{ENAME:’FORD’}), (b:DEPT{DNAME:’ACCOUNTING’})
CREATE(a)-[:DEPARTMENT] ->(b)
MATCH (a:EMP{ENAME:’ADAMS’}), (b:DEPT{DNAME:’RESEARCH’})
CREATE(a)-[:DEPARTMENT] ->(b)
MATCH (a:EMP{ENAME:’MILLER’}), (b:DEPT{DNAME:’SALES’})
CREATE(a)-[:DEPARTMENT] ->(b)
MATCH (a:EMP{ENAME:’BLAKE’}), (b:DEPT{DNAME:’OPERATIONS’})
CREATE(a)-[:DEPARTMENT] ->(b)
MATCH (a:EMP{ENAME:’JACK’}), (b:DEPT{DNAME:’ACCOUNTING’})
CREATE(a)-[:DEPARTMENT] ->(b)
//listeleme
match(n:EMP) return n
match(n:DEPT) return n
//işi analyst olan kayıtları listeleme
match(n:EMP) where n.JOB=”ANALYST” return n
//maaşı 2000’den aşağı olan kayıtları listeleme
match(n:EMP) where n.SAL<2000 return n
//kayıt güncelleme
MATCH (p:EMP{ENAME:’MILLER’})
SET p.ENAME = ‘MILER’
RETURN p
//kayıt silme
MATCH (p:EMP)
WHERE p.ENAME = ‘MILER’
DELETE p
//ilişki Silme
MATCH ()-[r:IS_IN]-()
DELETE r
//Node Silme
MATCH (e:EMP)
DELETE e