[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