> I'm have a little question regarding jdbc & mysql
> How can i create a record a record using executeUpdate("INSERT INTO ...")
> command and in the same step get the id (an auto increment field) of the
> newly created recorded in the same step?
> Right now i create the record followed by a select to determine the id of
> the newly created record, but this seems like an overkill to me.
> PS. Please respond to me directly since i'm not subscribed to the list.
> Tiago Pascoal (l41484@stripped) FAX : +351-1-7273394
You have two options:
after inserting a new row with auto_increment feature.
2) use the built in feature of your JDBC driver (these are different, so you have to look
for this in their documentation).
PS: Sorry for the late answer, I was on vacation.