From: Ed Carp
Date: March 12 1999 9:37am
Subject: Re: Inserting id's into AUTO_INCREMENT tables
List-Archive: http://lists.mysql.com/mysql/109
Message-Id: <199903120937.DAA14795@wats-ts4-12.ppp.iadfw.net>
Content-Type: text

Attachment: <a href="/mysql/109/1">[text]</a><br />
> 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?

By definition, an auto-incrementing field is just that.  If you want the
behavior you descripe, you'll have to do the incrementing yourself.

From your comments, as well as several people the passt few days, I get
the distinct impression that most people here haven't the faintest idea of
how a relational database works, or how to write SQL.  I'd really advise
people to get a good book on SQL and relational databases and familiarize
themselves with relational database concepts before posting stuff like
this.  Please don't take this as a flame, caue it's not, it's just a
little frustration about reading question after question from folks who
clearly haven't a clue as to what they're doing.  Not having a clue isn't
permanent - it just takes a little education.
--
Ed Carp, N7EKG  	erc@stripped		940/367-2744 cell phone
Owner: WeatherAlert/Digital Weatherman - NWS alerts via email/pager/Internet
       DSOUTH-L backup, Terrorism, Shamanism, Hurricane mailing lists
		http://www.pobox.com/~erc

"i have my plans and brave ambitions, knowing no bounds, no inhibitions..."
Basia Trzetrzelewska, "Third Time Lucky"