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
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
