8 messages in com.mysql.lists.win32Re: Fw: getting ID back after an inse...
FromSent OnAttachments
Mark Mchugh22 Aug 2005 07:21 
Tony Yau22 Aug 2005 07:33 
Daniel da Veiga22 Aug 2005 08:53 
Matt Bernhardt22 Aug 2005 09:21 
Daniel da Veiga22 Aug 2005 10:57 
Fredrick Bartlett22 Aug 2005 11:13 
SGr...@unimin.com22 Aug 2005 12:50 
Fredrick Bartlett23 Aug 2005 09:13 
Subject:Re: Fw: getting ID back after an insert statement
From:Matt Bernhardt (bern@osu.edu)
Date:08/22/2005 09:21:59 AM
List:com.mysql.lists.win32

I believe the statement is:

SELECT LAST_INSERT_ID();

http://dev.mysql.com/doc/mysql/en/information-functions.html

Hope this helps... Matt bern@osu.edu

On Mon, 22 Aug 2005 12:53:23 -0300, Daniel da Veiga <dani@gmail.com> wrote:

Check the list of methods for the connection object, there is one to get the last AI value inserted with the connection.

-- Matt Bernhardt, bern@osu.edu Systems Analyst - Student Computing Knowlton School of Architecture The Ohio State University