List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 17 2001 1:59am
Subject:Re: Foreign Key Info error in manual
View as plain text  
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().
Thread
Foreign Key Info error in manualScott Gerhardt17 Jan
  • Re: Foreign Key Info error in manualDan Nelson17 Jan
    • RE: Foreign Key Info error in manualScott Gerhardt17 Jan
      • Re: Foreign Key Info error in manualJeremy D. Zawodny17 Jan
        • RE: Foreign Key Info error in manualScott Gerhardt17 Jan
          • Re: Foreign Key Info error in manualJeremy D. Zawodny17 Jan
      • Re: Foreign Key Info error in manualPaul DuBois17 Jan
        • RE: Foreign Key Info error in manualScott Gerhardt17 Jan
      • Re: Foreign Key Info error in manualBenjamin Pflugmann17 Jan
        • RE: Foreign Key Info error in manualScott Gerhardt17 Jan
  • Re: Foreign Key Info error in manualJeremy D. Zawodny17 Jan