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]