ssage-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 2:40 PM
To: Andrew Kuebler
Cc: [EMAIL PROTECTED]
Subject: Re: Selecting Information Just Inserted
On Friday, April 19, 2002, at 02:10 PM, Andrew Kuebler wrote:
> I'm inserting data with an AUTO_INCREME
At 14:10 -0400 4/19/02, Andrew Kuebler wrote:
>Maybe someone can help me here..
>
>I'm inserting data with an AUTO_INCREMENT column and immediately after I
>need to use that new number for a corresponding record in another table.
>How am I able to extract that new number quickly? I could run a SEL
On Friday, April 19, 2002, at 02:10 PM, Andrew Kuebler wrote:
> I'm inserting data with an AUTO_INCREMENT column and immediately after I
> need to use that new number for a corresponding record in another table.
> How am I able to extract that new number quickly? I could run a SELECT
> query af
Hi, Andrew,
To get the auto_increment value, simply execute
select last_insert_id()
after insert statement
Andrew Kuebler wrote:
>Maybe someone can help me here..
>
>I'm inserting data with an AUTO_INCREMENT column and immediately after I
>need to use that new number for a corresponding record
