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 has

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

2003-06-23 Thread Matt Hyne
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 insert >> >