An exclusive table lock is the most restrictive mode of table
lock, allowing the transaction that holds the lock exclusive write access to the table. An
exclusive table lock is acquired for a table as follows:
LOCK TABLE table IN EXCLUSIVE MODE;
Permitted Operations: Only one transaction can obtain an exclusive table lock for a table.
An exclusive table lock permits other transactions only to query the table.
Prohibited Operations: An exclusive table lock held by a transaction prohibits other
transactions from performing any type of DML statement or placing any type of lock
on the table.
排他表锁
1. 限制程度最大的表锁
2. 获得排他表锁后允许的操作 : 只有一个事务能获得排他表锁 , 其他事务只能查询
3. 获得排他表锁后禁止的操作 : 禁止其他事务任何形式的DML操作 , 或者获得任何类型的锁
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-991298/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-991298/