Re: Unique Index?

[Paul DuBois]

At 4:29 PM -0500 6/10/99, Sweeney, Darren L wrote:
>Hi,
>
>Are all indexes unique?
>
>If not, how do I create a unique index?

Indexes that are specified with UNIQUE or PRIMARY KEY keywords
when you create the index are unique.  Others are not.

Check the syntax for CREATE TABLE, ALTER TABLE, and CREATE INDEX
in Chapter 7 of the MySQL Reference Manual.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/