Who knows all sql queries Nested Set?

Question

MySQL

Please tell me (working) sql queries to update the left_key and right_key keys when adding, deleting and moving nodes. I would like to see how you do it.

Answer 1

An almost textbook article on this topic is Managing Hierarchical Data in MySQL .
A Russian-language article on Habré containing listings of a complete set of ready-made triggers for working with nested sets in PostgreSQL - Nested Sets + PostgreSQL TRIGGER .