Further Question with -- table lock - which connection id own's it

Hi ... just wanted to added another question to this one... you suggested to use LAST_INSERT_ID() , but the question is if there are concurrent access to the database, how will you get the last id without locking the table. Because what I've been doing is also: 1. lock the table 2. get the id

Re: Further Question with -- table lock - which connection id own's it

*** REPLY SEPARATOR *** Hi ... just wanted to added another question to this one... you suggested to use LAST_INSERT_ID() , but the question is if there are concurrent access to the database, how will you get the last id without locking the table. Don't worry about

Re: Further Question with -- table lock - which connection id own's it

- From: Luciano Barcaro [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 9:49 AM Subject: Re: Further Question with -- table lock - which connection id own's it *** REPLY SEPARATOR *** Hi ... just wanted to added another question to this one... you

RE: Further Question with -- table lock - which connection id own's it

* Shaun Bramley Depending on how many people are updating this db should ultimately determine your decision to remove the table locks. If hte db is only experiencing one person updating it then it is not necessary. However if multiple people are updating it, then you will want to keep the