… common queries that are difficult if you store hierarchies according to textbook solutions. CREATE TABLE TreePaths ( ancestor… be tricky in both Closure Table and the Nested Sets model. It can be easier with the… table in a single query in MySQL. But we can use MySQL‘s multi-table DELETE syntax, to…

