<div>
See <a href="http://dev.mysql.com/doc/refman/5.0/en/internal-locking.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/internal-locking.html</a>&nbsp;there all your questions are answerd
</div>


See http://dev.mysql.com/doc/refman/5.0/en/internal-locking.html [http://dev.mysql.com/doc/refman/5.0/en/internal-locking.html] there all your questions are answerd

<div>
I cannot seem to find the answers you refer to in that link. &nbsp;Would you cut and paste the actual text you are referring to that answer each of the three questions?
</div>


I cannot seem to find the answers you refer to in that link.  Would you cut and paste the actual text you are referring to that answer each of the three questions?

<div>
<div class="content wysiwyg-content">
I am using the following code:<br />
<br />
&nbsp;LOCK TABLES matrix WRITE;<br />
&nbsp;UPDATE matrix SET dollarsGained = dollarsGained - 10;<br />
&nbsp;UNLOCK TABLES;<br />
<br />
1) How doI check that the table is actually locked?<br />
2) How do I just unlock the table 'matix' without unlocking all of them?<br />
3) How do I check that the table is actually unlocked?<br />
<br />
Server info:<br />
MySQL 5.0.45-community-nt via TCP/IP<br />
MySQL Client Version 5.1.11<br />
MYISAM tables
</div>
</div>


I am using the following code:

 LOCK TABLES matrix WRITE;
 UPDATE matrix SET dollarsGained = dollarsGained - 10;
 UNLOCK TABLES;

1) How doI check that the table is actually locked?
2) How do I just unlock the table 'matix' without unlocking all of them?
3) How do I check that the table is actually unlocked?

Server info:
MySQL 5.0.45-community-nt via TCP/IP
MySQL Client Version 5.1.11
MYISAM tables

Locking &amp; Unlocking Tables in MySql

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Locking &amp; Unlocking Tables in MySql

Locking & Unlocking Tables in MySql