By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
10.3.22-MariaDB |
Node | ParentNode | EmployeeID | Depth | Lineage |
---|---|---|---|---|
100 | null | 1001 | 0 | / |
101 | 100 | 1002 | 1 | /100/ |
102 | 101 | 1003 | 2 | /100/101/ |
103 | 102 | 1004 | 3 | /100/101/102/ |
104 | 102 | 1005 | 3 | /100/101/102/ |
105 | 102 | 1006 | 3 | /100/101/102/ |
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'UPDATE tree t, prev p SET t.Depth=p.Depth, t.Lineage=p.Lineage WHERE t.Node=p.No' at line 7