Tag

Hierarchical Data

0 views collected around this technical thread.

Selected Java Interview Questions

Mar 12, 2024 · Databases

Understanding Recursive Queries in MySQL with Practical Examples

This article explains MySQL recursive queries using WITH RECURSIVE, detailing their structure, execution process, common use cases, and provides a step‑by‑step example with table creation, data insertion, and a paginated hierarchical query.

Hierarchical DataRecursive QuerySQL

0 likes · 9 min read

Understanding Recursive Queries in MySQL with Practical Examples

Code Ape Tech Column

Apr 11, 2022 · Databases

Managing Hierarchical Department Data with the Nested Set Model in MySQL

This article explains how to replace parent‑id based tree storage with the nested set model, showing SQL queries to retrieve descendants, count them, detect leaf nodes, and perform insert, delete, and other operations, plus a JavaScript example for rebuilding the hierarchy.

DatabaseHierarchical DataNested Set

0 likes · 9 min read

Managing Hierarchical Department Data with the Nested Set Model in MySQL