Re: Inserting id's into AUTO_INCREMENT tables

[Thimble Smith]

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