Thanks Paul,
And it doesn't really matter if the ID's are cronological that's what
timestamps are for.
___________________________________
Scott A. Gerhardt P.Geo.
Gerhardt Information Technologies
[EMAIL PROTECTED]
___________________________________
>
> On Tue, Jan 16, 2001 at 07:22:48PM -0600, Scott Gerhardt wrote:
> > So referential integrity is maintained but AUTO_INCREMENT
> values may not be
> > chronological?
> >
> > Connection A's LAST_INSERT_ID() may be 3 at 15:20
> > AND
> > Connection B's LAST_INSERT_ID() may be 4 at 15:18
>
> The AUTO_INCREMENT values will be *generated* in sequence. It's possible
> that they may not be *used* in sequence, depending on the delay between
> the INSERT that generated the value and the following statements in which
> you refer to it using LAST_INSERT_ID().
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php