MySQL Lists are EOL. Please join:

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.


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