List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:March 12 1999 2:03pm
Subject:Re: Inserting id's into AUTO_INCREMENT tables
View as plain text  
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

Thread
Inserting id's into AUTO_INCREMENT tablesMorten12 Mar
  • Re: Inserting id's into AUTO_INCREMENT tablesThimble Smith12 Mar
  • Re: Inserting id's into AUTO_INCREMENT tablesChristian Mack12 Mar
  • Re: Inserting id's into AUTO_INCREMENT tablesEd Carp12 Mar
  • Re: MySQL 3.23.24 releasedJerome Abela11 Sep
    • Re: MySQL 3.23.24 releasedMichael Widenius11 Sep
  • Re: MySQL 3.23.24 releasedDan Pelton12 Sep
Re: MySQL 3.23.24 releasedRichard Ellerbrock12 Sep
  • RE: MySQL 3.23.24 releasedSander Pilon12 Sep