What Not To Do With Databases

Transcript

9. CREATE TABLE Employee ( id int primary key, name varchar(255) not null, manager_id int );
10. SELECT m.name FROM Employee e INNER JOIN Employee m ON e.manager_id = m.id WHERE e.id = 100;
11. WITH RecursiveCte AS ( SELECT e.id, e.name FROM Employee e WHERE parent_id = 100 UNION ALL SELECT e.id, e.name FROM Employee e INNER JOIN RecursiveCte rcte ON e.parent_id = rcte.id ) SELECT Name FROM RecursiveCte;
13. MATCH (e { id: 100 })-[:MANAGED_BY]->(m) RETURN m.name;
14. MATCH (m { id: 100 })<-[:MANAGED_BY*]-(e) RETURN e.name;
15. MATCH (m { id: 100 })<-[:MANAGED_BY*]-(e) RETURN e.name;