|
|
LOCK TABLES table_name [AS alias] {READ | [READ LOCAL] | [LOW_PRIORITY] WRITE} [,table_name {READ | [LOW_PRIORITY] WRITE} ...]
LOCK TABLES places a lock on the specified tables. The lock can be READ (other connections cannot write, only read), READ LOCAL (same as READ except that writes from other connections that do not conflict are allowed), or WRITE (which blocks reading or writing from other connections). If the WRITE lock is LOW PRIORITY, READ locks are placed first. Usually WRITE locks have higher priority.
|
|