| Jonathan Leffler 2007-04-07, 9:58 pm |
| movingsnail@gmail.com 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-
>
> 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@perl.org 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@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2007.0226 -- http://dbi.perl.org/
|