From: Dan Nelson
Date: March 8 2006 4:52am
Subject: Re: Table with multiple primary keys - How
List-Archive: http://lists.mysql.com/mysql/195517
Message-Id: <20060308045253.GA24511@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Mar 07), fbsd_user said:
> What I am trying to do here is have 3 separate primary keys. Creating
> a mysql select on either of the Logon_id, email_addr, or last_name
> fields will do a single read to the matching value.  Like having 3
> different indexes into the same table.

Create one primary key and two unique indexes.  As far as mysql is
concerned, a primary is just another unique index.  I'd make login_id
the real primary key since it should never change, unlike email_addr or
last_name.  Are you sure you want last_name to be unique?  I think that
one should be just a regular index.

-- 
	Dan Nelson
	dnelson@stripped