List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 29 2001 5:22pm
Subject:Re: multiple PRI indexes
View as plain text  
At 10:33 AM -0500 8/29/01, shawn reed wrote:
>is it generally recommended / a good idea to have more than one PRI index
>in the same table?  i've never seen that before until today while trying
>to track down bugs in someone else's system and noticed a table with 2 PRI
>indexes.  will this cause any problems?


In MySQL, you cannot have two PRIMARY KEY indexes.  You can have a PRIMARY
KEY and and a UNIQUE index, or two UNIQUE indexes, but that's a slightly
different situation.

>Before posting, please check:
>   (the manual)
>           (the list archive)
>To request this thread, e-mail <mysql-thread83911@stripped>
>To unsubscribe, e-mail <>
>Trouble unsubscribing? Try:

Paul DuBois, paul@stripped
multiple PRI indexesshawn reed29 Aug
  • RE: multiple PRI indexesChris Bolt29 Aug
  • Re: multiple PRI indexesPaul DuBois29 Aug
    • Re: multiple PRI indexesDavid Turner29 Aug