List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 31 2000 10:28pm
Subject:Re: Getting the record just inserted.
View as plain text  
At 5:18 PM -0500 01-31-2000, James Treworgy wrote:
>At 07:00 PM 1/31/00 -0300, Horacio J. Peña wrote:
>>Ah, sorry. I hadn't understood you. Thanks! And, what happens if i do an
>>insert, other process do another insert. When i do that select what do i get?
>
>Hmmmm... I'd guess you need to lock the table before your insert to 
>absolutely ensure data integrity. (TCX?)  See LOCK_TABLES and UNLOCK 
>in the manual.

No, the mysql_insert_id() value (or $dbh->{mysql_insertid} or SELECT
LAST_INSERT_ID() value) is per-client.  Insert activity by other clients
doesn't affect it.

-- 
Paul DuBois, paul@stripped
Thread
Getting the record just inserted.Horacio J. Peña1 Feb
  • Re: Getting the record just inserted.James Treworgy1 Feb
    • Re: Getting the record just inserted.Horacio J. Peña1 Feb
      • Re: Getting the record just inserted.James Treworgy1 Feb
        • Re: Getting the record just inserted.Horacio J. Peña1 Feb
          • Re: Getting the record just inserted.James Treworgy1 Feb
            • Re: Getting the record just inserted.James Treworgy1 Feb
            • Re: Getting the record just inserted.Paul DuBois1 Feb
  • Re: Getting the record just inserted.Faisal Nasim1 Feb
  • Re: Getting the record just inserted.sinisa1 Feb