Re: DBI Last Inserted ID

movingsnail@xxxxxxxxx wrote:
i have been search around for the way to access the recent inserted
row to get the id from auto incremented col.
there are a lot of ways to access that col. such as $dbh-
{'mysql_insertid'} etc.

what i am wondering is this will the statement $dbh-> {'mysql_insertid'} give the id that i want.
what if there are many other connections to the database and
constantly inserting other rows.
will that mess up the whole purpose of get back the id;

You'd do better, probably, on the dbi-users@xxxxxxxx mailing list.

If the driver is implemented properly, activity on a separate database handle ($dbh2, say) definitely won't (shouldn't) affect the insert ID on the current one ($dbh1). If I was asked, I'd the say the same of statement handles on the same $dbh; $st1 and $st2 should be able to have separate 'last inserted ID' values (and DBD::Informix implements that), but I'm not sure what the DBI spec (perldoc DBI) has to say about it.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@xxxxxxxxxxxxx, jleffler@xxxxxxxxxx
Guardian of DBD::Informix v2007.0226 -- http://dbi.perl.org/
.