[thelist] Multi-level data storage
Andrew Forsberg
andrew at thepander.co.nz
Tue Feb 27 16:31:52 CST 2001
> > I would have thought that the LinkID would need to
>> appear multiple times with each CatID that applied,
>
>and so it can
>
>there is an alternate way to do this, which is to create an auto_increment
>primary key for this table, and then the above two columns can just be
>carried along as data -- but this method is unnecessary if the database can
>handle the first method (using a composite primary key)
>
>helps?
Hi Rudy,
Rock and roll! Yes that helps. I should check the MySQL documentation
in case they don't support composite primary keys... but otherwise
that's a very cool way to do it.
Thank you,
Andrew
--
Andrew Forsberg
http://www.thepander.co.nz
More information about the thelist
mailing list