[MySQL] WITH RECURSIVE / 재귀쿼리 재귀호출 계층형쿼리
MySQL 버전: 8.0.35 댓글 테이블 ↓ 댓글 테이블 데이터 예시 ↓ query ↓ select * from (WITH RECURSIVE CTS AS ( SELECT comments.* , 0 as lvl , cast(comments.comment_id as char) as path FROM comments WHERE upper_id = 0 AND store_id = 1 UNION ALL SELECT u.*, CTS.lvl+1, concat(CTS.path, ',', cast(u.comment_id as char)) FROM comments u INNER JOIN CTS ON u.upper_id = CTS.comment_id ) SELECT comment_id, user_id, recipe_id, ..
2023. 12. 15.