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. here
UNLOCK TABLE mytbl;

-- 
See you,
Andrey.

[ [EMAIL PROTECTED] | ICQ# 114087545 | 2:5090/[EMAIL PROTECTED] ]

...I know on which side my bread is buttered. -- John Heywood


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to