12 messages in com.mysql.lists.javaRe: returning identity field from a s...
FromSent OnAttachments
MHa...@ica.com.au15 Jul 2002 19:28 
Jeff Kilbride15 Jul 2002 20:44 
Mark Matthews15 Jul 2002 20:46 
Tim Endres15 Jul 2002 20:56 
Steve Forsyth15 Jul 2002 20:57 
Javier Bolaños Molina(MCIC)15 Jul 2002 23:20 
Andrew Houghton16 Jul 2002 09:23 
Steve Forsyth16 Jul 2002 11:20 
Mark Matthews16 Jul 2002 12:26 
Jon Frisby18 Jul 2002 20:12 
Mark Matthews18 Jul 2002 20:55 
Jon Frisby19 Jul 2002 11:24 
Subject:Re: returning identity field from a select statement
From:Mark Matthews (mmat@thematthews.org)
Date:07/18/2002 08:55:05 PM
List:com.mysql.lists.java

----- Original Message ----- From: "Jon Frisby" <jfri@yourfreedvds.com> To: "Jeff Kilbride" <je@kilbride.com>; <ja@lists.mysql.com>; <MHa@ica.com.au> Sent: Thursday, July 18, 2002 10:12 PM Subject: RE: returning identity field from a select statement

IIRC, getLastInsertID() is a wrapper for "SELECT LAST_INSERT_ID()". Thus, the latter is generally preferrable because you aren't tying your code to a particular MySQL JDBC driver...

Not really, because the driver doesn't have to issue a query when you call getLastInsertId() (it's passed back as part of the client-server protocol). Howerver, it is database-specific.

The next version of MM.MySQL will support getGeneratedKeys() fully in all types of Statements, and doesn't require a query to do it (so it's faster than executeQuery("SELECT LAST_INSERT_ID()")).

-Mark