ROW SHARE Permits concurrent access to the locked table, but prohibits other users from locking the entire table for exclusive access.
ROW EXCLUSIVE Same as ROW SHARE, but also prohibits locking in SHARE mode. This type of lock is obtained automatically with standard DML commands such as UPDATE, INSERT, or DELETE.
SHARE Permits concurrent queries but prohibits updates to the table; this mode is required to create an index on a table and is automatically obtained when using the CREATE INDEX statement.
SHARE ROW EXCLUSIVE Used to query a whole table and to allow other users to query the table, but to prevent other users from locking the table in SHARE mode or updating rows.
EXCLUSIVE The most restrictive locking mode; permits queries on the locked table but prohibits any DML by any other users. This mode is required to drop the table and is automatically obtained when using the DROP TABLE statement.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10314474/viewspace-617818/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- C#之Equals与==
- Spring ： @SessionAttributes注解
- Spring: @ModelAttribute注解用法
- No qualifying bean of type 'javax.sql.DataSource' available: expected at least 1
- Spring Boot创建DataSource时遇到的错误：No supported DataSource type found
- Spring Boot无法对Service进行注入
- Spring Boot配置错误：Failed to determine a suitable driver class
- Spring Boot配置是遇到错误：jdbcUrl is required with driverClassName
- Eclipse中使用Mybatis Generator遇到的错误
- Spring Boot + Mybatis + Spring MVC环境配置（五）：templates模板使用
