how to retrieve the new ID of the auto_increment column

[metridevkk]

I am using mysql database.
In my jsp page, after inserting a record in the mysql table, I need to get back the new ID generated for the auto_increment primary key column. How do I get this value?

 

[stefanwagner]

you should still know your data to get it by a query.

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[chiph]

Does mysql use the @@IDENTITY variable?

If so, it would be:
SELECT @@IDENTITY;

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[metridevkk]

Thanks. I found the solution as follows:

stmt.executeUpdate(insertSQL,Statement.RETURN_GENERATED_KEYS);

int autoIncKeyFromApi = -1;

rs = stmt.getGeneratedKeys();

if (rs.next()) {
autoIncKeyFromApi = rs.getInt(1);
} else {
// throw an exception from here
}