Hi all,
I am using mod_perl and MySQL w/DBI and am concerned if I enter a record into a table and then go back to get the auto_increment field with a last_insert_id() DBI command that I may get the actual last_insert_id of a client which may be hitting my script at the same time. DBI keeps the connection open when used with mod_perl so if i understand the mysql last_insert_id command, I may get someone else's last_insert_id back. Does anybody know for sure how this works? The MySQL documentation doesn't go into this.
I am using mod_perl and MySQL w/DBI and am concerned if I enter a record into a table and then go back to get the auto_increment field with a last_insert_id() DBI command that I may get the actual last_insert_id of a client which may be hitting my script at the same time. DBI keeps the connection open when used with mod_perl so if i understand the mysql last_insert_id command, I may get someone else's last_insert_id back. Does anybody know for sure how this works? The MySQL documentation doesn't go into this.