RE: Getting the unique auto-increment primary key after an insert

2003-06-24 Thread Matt Hyne
. 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 insert Hi Folks, needs a little advice. I have a table that contains a unique auto

Getting the unique auto-increment primary key after an insert

2003-06-23 Thread Matt Hyne
Hi Folks, needs a little advice. I have a table that contains a unique auto-incrementing primary key called 'id' (eg 1,2,3,4...). When inserting data, I let mySQL allocate the value that goes into this field. Now I want to insert a new row into this table and get the 'id' value that mySQL