Mysql seems to insists that all tables must be locked if one table is locked in a select statement. Why ?
For example-
lock tables A WRITE, B WRITE; select * from A, B, C where A.id=B.id and A.id=C.id;
Mysql will complain that table C is not locked. Is there a way to avoid locking table C ? I only want to modify table A and B. Table C is also used in some other select statement with other tables. If I lock table C, I will have to lock all these other tables too.
Thanks,.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
