From: Christian Mack
Date: March 12 1999 2:03pm
Subject: Re: Inserting id's into AUTO_INCREMENT tables
List-Archive: http://lists.mysql.com/mysql/97
Message-Id: <36E91EB4.6AE94250@compal.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Morten wrote:
> 
> Hey
> 
> Is it at all possible to have duplicates in an auto incremating
> tables? I'd like my table id to increase when a new value is
> inserted, but I'd also like duplicate values so I'm able to
> insert several relations from one id... Hmm. No?
> 
> Thanks
> 
> Morten

Hi Morten

Certaily you can have duplicates in an AUTO_INCREMENT field.
You only have to specify this field with KEY and not with PRIMARY KEY or UNIQUE KEY.
Then you can insert duplicates.

Tschau
Christian