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.
,
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
Thanks,
I found it but I wasn't sure
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 if
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