Re: Lock table in MySQL

[Aftab Khan]

A table lock protects only against inappropriate reads or writes by other sessions. The session holding the lock can perform read/operation, for example

mysql> show create table t1;
+-------+--------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+--------------------------------------------------------------------------------------+
| t1 | CREATE TABLE `t1` (
`a` char(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+-------+--------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> lock table t1 write;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t1 values (2);
Query OK, 1 row affected (0.01 sec)