row so I can use that the value of a foreign key in another relation?
That's database specific, and you haven't specified a database.
* 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
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 see
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 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 to a
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_insert_id()
or
Select mysql_insert_id() from TABLE_NAME
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 MySQL.
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_insert_id()