MySQueaL Resources

resources for mysql admins and developers who are squealing for help

More Resources

Main Doc Pages
Privileges Required
  • LOCK TABLES
  • SELECT
Comments
MySQL columns: everywhere I look are tables and columns; life is filled with databases of information to be ordered and grouped. (Ca'Grande, Milan, Italy)

UNLOCK TABLES Statement

Use this MySQL statement to unlock tables that were locked by the current connection thread with the LOCK TABLES statement.

hits past month: 18 ;  last updated: may 4, 2009 - 2:34am ;  parent: MySQL Table & Server Administration Statements

Syntax

UNLOCK TABLES

Explanation

Use this statement to unlock tables that were locked by the current connection thread with the MySQL statement LOCK TABLES or by FLUSH TABLES WITH READ LOCK. UNLOCK TABLES implicitly commits any active transactions if any tables were locked with LOCK TABLES. When performing a large amount of changes to data in MyISAM tables, it can be useful and faster to lock the tables first. This way the key cache isn't flushed after each SQL statement. Instead, the server flushes the key cache when executing UNLOCK TABLES.

There are no examples for this page of our documentation. Return to MySQL Table & Server Administration Statements page of our MySQL Documentation