如下所示:
lock table account write;
如上命令,我手动给表 account 加了表级的排他锁,接着我如何释放锁呢?
如下所示:
lock table account write;
如上命令,我手动给表 account 加了表级的排他锁,接着我如何释放锁呢?
这类问题,亲自查一下MYSQL官方免费手册不就知道了?
13.3.6 LOCK TABLES and UNLOCK TABLES Syntax
LOCK TABLES
tbl_name [[AS] alias] lock_type
[, tbl_name [[AS] alias] lock_type] ...
lock_type: {
READ [LOCAL]
| [LOW_PRIORITY] WRITE
}
UNLOCK TABLES
MySQL enables client sessions to acquire table locks explicitly for the purpose of cooperating with
other sessions for access to tables, or to prevent other sessions from modifying tables during periods
when a session requires exclusive access to them. A session can acquire or release locks only for
itself. One session cannot acquire locks for another session or release locks held by another session.
Locks may be used to emulate