On 7/5/07, David T. Ashley <[EMAIL PROTECTED]> wrote:
>
> a)I'm assuming that under MySQL I have to create a third table that maps
> between them? (Let's call it "users2priveleges".)
>
> b)I'm assuming that there is nothing special I need to do to get, for
> example, all the priveleges with a user (just the standard join stuff
> with
> x=y and y=z or something like that)?
>
> c)I'm assuming that from an optimization point of view, there is nothing
> I
> can/should do beyond optimizing the links, i.e. making sure the related
> fields are indexed?
On 7/5/07, Dan Buettner <[EMAIL PROTECTED]> wrote:
David, you've hit the nail on the head.
> >
> > Dan
> >
>
Hi Dan,
Thanks for the feedback.
My recollection is that old versions of Access had some functionality where
you would relate the tables many:many and the product would "hide" the third
table from you.
Just wanted to be sure there was no such functionality in MySQL (not that
I'd want it, anyway).
And just wanted to be sure there is nothing further I could tell MySQL in
order to optimize this kind of relation.
Thanks.
