Re: Inserting id's into AUTO_INCREMENT tables

[Christian Mack]

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