On Apr 12, 2005 1:37 AM, Siegfried Heintze <[EMAIL PROTECTED]> wrote:
> Thanks, JP.
> And will this work for multi-threaded, multi-user applications?
> Siegfried
Yes:
"The last ID that was generated is maintained in the server on a
per-connection basis. This means the value the function returns t
Thanks, JP.
And will this work for multi-threaded, multi-user applications?
Siegfried
-Original Message-
From: Jan Pieter Kunst [mailto:[EMAIL PROTECTED]
Sent: Monday, April 11, 2005 3:05 PM
To: mysql@lists.mysql.com
Subject: Re: How to call mysql_insert_id
On Apr 11, 2005 10:50 PM
On Apr 11, 2005 10:50 PM, Siegfried Heintze <[EMAIL PROTECTED]> wrote:
> * In MySQL - mysql_insert_id()
>
> How do I call this function? I was hoping I could use SQL such as "SELECT
> mysql_insert_id() FROM XYZ" but I discovered that does not work. I'm using a
> mixture of java and perl. I
At 6:45 PM -0500 9/30/01, Reuben D Budiardja wrote:
>Hi,
>I am a newbie in MySQL. I use an auto_increment to insert to one of the
>column. How do I get the value inserted?
>
>The documentation seems to suggest using mysql_insert_id() function. But when
>I tried to call it using
>Select mysql_inser
You were close to it.
But he way to get the last inserted item on AUTO_INCREMENT field is for
example:
id = mysql_insert_id(&mysql);
printf("The last insert is: %d\n", id);
And mysql is what was return to you when you open your connection to the
database.
Daniel
> Hi,
> I am a newbie in MyS
