Re: returning identity field from a select statement

[Tim Endres]

You need to follow your insert with this:

    SELECT LAST_INSERT_ID();

which will return a ResultSet with one row with one column
containing your ID. See 6.3.6.2 Miscellaneous Functions in
the documentation.


> MYSQL already has a function mysql_insert_id() for use in the C API but
> this does not work in java.
> 
> Is there an equivalent function that I can use in my Java servlet to return
> the identity field after an insert ?
> 
> I am using the version 1.4 JDK and the version 2.0.14 MM.MYSQL JDBC Driver
> for mySQL .
> 
> I am using version 3.23.36 of mySQL.
> 
> Can anyone help ?