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, 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 in my old documentation that PHP
programmers
> can call such a function.

SELECT LAST_INSERT_ID();

HTH,
JP

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to