From: Thimble Smith
Date: March 12 1999 3:26pm
Subject: Re: Inserting id's into AUTO_INCREMENT tables
List-Archive: http://lists.mysql.com/mysql/88
Message-Id: <19990312082623.A28088@desert.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On Fri, Mar 12, 1999 at 09:36:27AM +0100, Morten wrote:
> 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?

It's possible (just declare the column a normal KEY instead of
PRIMARY or UNIQUE).  But I'd say that it's probably not the
right thing to do.  Your data could probably be organized in
a better way if you're trying to use an auto_increment field in
that way.

Tim