last_insert_id() returns the last auto-increment your connection. Another
connection might make an insert and the auto-increment may change between
the time you insert and get your last_insert_id();
Curtis
On Tue, 24 Jun 2003, Matt Hyne wrote:
>
> Thanks,
>
> I found it but I wasn't sure
,
Lian
www.programEz.net
> -Original Message-
> From: Matt Hyne [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 24, 2003 9:07 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Getting the unique auto-increment primary key after an
> insert
>
>
>
> Thank
Thanks,
I found it but I wasn't sure if it could be changed between my INSERT
and the SELECT LAST..() by another instance of my application.
I'll suck-it-and-see !
Matt
[EMAIL PROTECTED] wrote:
> The good ol' LAST_INSERT_ID() function is what you probably need.
Check it
> out in manual.
>
>
The good ol' LAST_INSERT_ID() function is what you probably need. Check it
out in manual.
Lian
> -Original Message-
> From: Matt Hyne [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 24, 2003 5:58 AM
> To: [EMAIL PROTECTED]
> Subject: Getting the unique auto-increment primary key after an
