LOCK TABLES Syntax

• The LOCK TABLES syntax is:

  LOCK TABLES tbl_name [AS ] {READ [LOCAL] | [LOW_PRIORITY] WRITE} [, tbl_name [AS alias] {READ [LOCAL] | [LOW_PRIORITY] WRITE}]

• LOCK TABLES locks base tables (but not views) for the current thread.
  • If any of the tables are locked by other threads, it blocks until all locks can be acquired.

• To use LOCK TABLES, one must have LOCK TABLES and SELECT privileges for the tables involved.

• UNLOCK TABLES explicitly releases any locks held by the current thread.

How do I use the FLUSH statement?

---

---

© 2007 John Michael Pierobon

Notes