Re: recursive search
From: Jerry Stuckle <jstucklex_at_attglobal.net>
Date: Mon, 12 Sep 2016 08:46:56 -0400
Message-ID: <nr683n$4c0$1_at_jstuckle.eternal-september.org>
>
> Yes. SQL has the CONNECT BY PRIOR clause to allow recursive queries.
> However it is not supported by MySQL (or any of it's forks)
>
> If you google with this term, you will find several approaches how to deal
> with this using MySQL facilities. Including different modeling of hierarchic
> data (nested set model etc.)
>
Date: Mon, 12 Sep 2016 08:46:56 -0400
Message-ID: <nr683n$4c0$1_at_jstuckle.eternal-september.org>
On 9/12/2016 4:19 AM, Axel Schwenke wrote:
> [snip]
>
>> Is there a way to achieve this just using sql ?
>
> Yes. SQL has the CONNECT BY PRIOR clause to allow recursive queries.
> However it is not supported by MySQL (or any of it's forks)
>
> If you google with this term, you will find several approaches how to deal
> with this using MySQL facilities. Including different modeling of hierarchic
> data (nested set model etc.)
>
No, recursive SQL uses "WITH (col1, col2, col3) AS" ...
CONNECT BY PRIOR is for hierarchical queries. Different things.
-- ================== Remove the "x" from my email address Jerry Stuckle jstucklex_at_attglobal.net ==================Received on Mon Sep 12 2016 - 14:46:56 CEST