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

2002-04-23 Thread Roger Baklund
* 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 th

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

2002-04-23 Thread Shaun Bramley
- 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 wante

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

2002-04-23 Thread Luciano Barcaro
*** 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 c