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

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