robably 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 th
,
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
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
>>
>
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
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
