Getting the id of a newly added record

Hi,

I have a MySQL database table, with a few fields, and the first field
is id, which is set to autoincrement. After adding an item to the
table, I need to know the id of the newly added item, so that I can
edit it afterwards. Is there any way to find the id of the item,
using either SQL or the Java MySQL library?

Just finding the item most recently added to the table would be risky,
because the table is going to be edited a lot, and by multiple
applications concurrently.

Thanks,

--James.

On Mon, 09 Feb 2009 02:52:01 -0800, james wrote:

> I have a MySQL database table, with a few fields, and the first field is
> id, which is set to autoincrement. After adding an item to the table, I
> need to know the id of the newly added item, so that I can edit it
> afterwards. Is there any way to find the id of the item, using either
> SQL or the Java MySQL library?
>
> Just finding the item most recently added to the table would be risky,
> because the table is going to be edited a lot, and by multiple
> applications concurrently.
>
run SELECT LAST_INSERT_ID(); immediately after the INSERT.

The manual says this is connection-specific, so not affected by activity
on other conections.

This isn't a Java question, so kindly RTFM in future before asking
database specific questions. It took me about 10 seconds to find this
answer in the manual - and I've never, ever used MySQL.


--
martin@ | Martin Gregorie
gregorie. | Essex, UK
org |