Re: Locking the tables

2003-12-19 Thread Binay
Hi Andrey, many thanks for quick response. plz find my further query below. - Original Message - From: "Andrey Subbotin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 19, 2003 12:27 PM Subject: Re: Locking the tables > > Hello Binay. &g

Re: Locking the tables

2003-12-18 Thread Andrey Subbotin
Hello Binay. Friday, December 19, 2003, 1:53:01 PM, you wrote: B> I want to put write lock on a(set of) table(s), so that only i B> can insert into it and no body else unless i remove the write lock. B> How can i achieve it?? AFAIR, you usu. do that with: LOCK TABLE mytbl WRITE; // do smth. her