Re: help with nested set
From: paul c <toledobythesea_at_oohay.ac>
Date: Mon, 13 Apr 2009 17:29:18 GMT
Message-ID: <ODKEl.23116$PH1.6487_at_edtnps82>
Date: Mon, 13 Apr 2009 17:29:18 GMT
Message-ID: <ODKEl.23116$PH1.6487_at_edtnps82>
lawpoop wrote:
> On Apr 13, 9:27 am, paul c <toledobythe..._at_oohay.ac> wrote:
...
> Are you asking why all of these example rows have a value for the
> client_id? Are you saying it should look like this? :
>
> id client_id parent_id level
> 1 1 NULL Corporate
> 2 NULL 1 Franchise 1
> 4 NULL 1 Eastern Region
> 5 NULL 4 New York District
> ...
No, assuming you plan to recurse a tree, how will you end the recursion?
> MySQL check constraints are somewhat limited; what would you suggest?
Can't help with MySQL. Received on Mon Apr 13 2009 - 19:29:18 CEST