You are viewing a plain text version of this content. The canonical link for it is here.

Posted to modperl@perl.apache.org by Octavian Rasnita <or...@gmail.com> on 2007/02/03 22:52:55 UTC

Apache::DBI

Hi,

Can you tell me, if I use persistent MySQL connection (with Apache::DBI), if 
I want to use select last_insert_id(), do I need to lock the table before 
doing the insert and unlock it after using the last_insert_id()?

I don't know what could happen if another user of the application makes 
another insert right after I do the same thing. I am afraid that it could 
return its last inserted ID and not mine.

Thank you.

Octavian