Recursive CTE in MySQL

Recursive CTE

Example: Numbers 1 to 5

WITH RECURSIVE nums AS (
  SELECT 1 AS n               -- anchor (start)
  UNION ALL
  SELECT n + 1 FROM nums WHERE n < 5   -- recursive step
)
SELECT * FROM nums;

Summary

• WITH RECURSIVE has an anchor query + a recursive query joined by UNION ALL.
• Used for hierarchies and generated sequences.

Recursive CTE

Example: 1 से 5 तक Numbers

WITH RECURSIVE nums AS (
  SELECT 1 AS n               -- anchor (शुरुआत)
  UNION ALL
  SELECT n + 1 FROM nums WHERE n < 5   -- recursive step
)
SELECT * FROM nums;

सारांश

• WITH RECURSIVE में anchor query + recursive query होती है, UNION ALL से जुड़ी।
• Hierarchies और generated sequences के लिए use होती है।