Re: locking question

2001-08-21 Thread Ken Guest
On 19 Aug 2001 19:29:17 +0100, Wesley Darlington wrote: > Hi, Howdy. > On Thu, Aug 16, 2001 at 02:04:25PM +0100, Ken Guest wrote: > > At the moment, what I am doing is: > > > > execute "LOCK TABLES foo READ" > > select info from foo > > //next lock implictly unlocks previous one > >

Re: locking question

2001-08-19 Thread Wesley Darlington
Hi, On Thu, Aug 16, 2001 at 02:04:25PM +0100, Ken Guest wrote: > At the moment, what I am doing is: > > execute "LOCK TABLES foo READ" > select info from foo > //next lock implictly unlocks previous one > //as it's done by the same thread/process > //chances of conf

Re: locking question

2001-08-18 Thread Benjamin David Hildred
On Thu, Aug 16, 2001 at 02:04:25PM +0100, Ken Guest wrote: > > hi, > I'm new to this list, but not so new to using MySQL and have a question > about locking. (This is my first foray into datalocking with MySQL.) > > I'd like to lock a table (a row in that table would be better) for read > and