You don't need the INDEX (email) at the end of this statement, it's
creating a second index on the same data. UNIQUE specifies that an index
should be created.
TJ Hunter <[EMAIL PROTECTED]> wrote:
I'm using the following table to store information about a merchant user.
He uses his email add
I think that KEY is the same as INDEX, but why UNIQUE?
- Original Message -
From: TJ Hunter <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 12, 2001 3:49 AM
Subject: indexing unique fields
> I'm using the following table to store information about a merchant user.
> H
