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.

>
>tia.
>
>~shawn
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread83911@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


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