Apache::DBI

2007-02-03 Thread Octavian Rasnita
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

RE: Apache::DBI

2007-02-03 Thread Rick Apichairuk
Let's say the user connects and fills out a form to create a new record in the Person table. Let's assume the Person table has an AUTO_INCREMENT column named 'id'. When the user clicks submit, the data in the form is submitted to your program which will then lock the table for write and insert the