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