Re: Multiple Primary Keys

[Paul DuBois]

At 9:56 AM -0500 9/25/99, Yuval Malchi wrote:
>Hi,
>
>I have two tables with a many to many relationship and
>they need an associative table which uses the primary
>keys from both tables.  Mysql tells me that "multiple
>primary keys defined".  Is this not possible to do in
>Mysql?  How do I get around it?

Use two UNIQUE indexes.  A table can have only one PRIMARY
KEY, but multiple UNIQUE indexes.

But perhaps what you really want is a two-column PRIMARY
KEY, given your description.  It's somewhat ususual to
have multiple unique indexes on a table.

--
Paul DuBois, paul@stripped