MySQL Lists are EOL. Please join:

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

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