操作

查看锁：show open tables; 加锁：lock table 表1 read,表2 write;给表1加上读锁，给表2加上写锁 解锁：unlock tables;

分类

读锁

读锁是共享锁。

当前连接(session1)对test表加上读锁时，当前连接及其他连接进行以下操作：

操作session1session2查询test表可以可以更新/插入test表报错(Table was locked with a READ lock and can’t be updated)阻塞，直到test表的读锁释放查询其他表报错Table was not locked with LOCK TABLES可以更新/插入其他表报错Table was not locked with LOCK TABLES可以