You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

UNLOCK TABLES

Unlock all table and database locks held by the current connection.

Syntax

UNLOCK TABLES

Remarks

  • Locks held by the current connection are automatically released when the current MemSQL connection is terminated.
  • This command must be run on the master aggregator or a child aggregator node (see Node Requirements for MemSQL Commands ).

Example

memsql> UNLOCK TABLES;
Query OK, 0 rows affected (0.00 sec)