|
|
|
|
|
|
|
|
|
|
version 11
LOCK TABLE sql_name IN {EXCLUSIVE | SHARE} MODE
Description
The LOCK TABLE command is used to lock the table named sql_name in either EXCLUSIVE or SHARE mode.
In EXCLUSIVE mode, the data of the table cannot be read or modified by another transaction.
In SHARE mode, the data of the table can be read by concurrent transactions but modifications are still prohibited.
Example
This example locks the MOVIES table so that it can be read but not modified by other transactions:
LOCK TABLE MOVIES IN SHARE MODE
See Also
|
|
|
|
|
|
|
|
|
|