Hello Binay.
Friday, December 19, 2003, 2:04:51 PM, you wrote:
B> Hi Andrey,
B> many thanks for quick response. plz find my further query below.
>> AFAIR, you usu. do that with:
>> LOCK TABLE mytbl WRITE;
>> // do smth. here
>> UNLOCK TABLE mytbl;
B> ++
B> How can i achieve the
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
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
Hi all,
I have mysql verison 3.23.58 and all tables in a database say test_database are of
MyIsam types.
I want to put write lock on a(set of) table(s), so that only i can insert into it and
no body else unless i remove the write lock. How can i achieve it??
Please help me out ..
Thanks in ad
Here is the part of the processlist from when the server was full...
| Id | User | Host | db | Command | Time | State|
Info
|
+--+---+---+--+-+--+--+-
