title: MySQL locking tables
body: <p>I'm trying to do a simple lock that prevents any other requests from reading or writing a single table. The results of my code after both being typed into and executed in phpmyadmin:</p>
  
  <pre><code>LOCK TABLES mytable WRITE;# MySQL returned an empty result set (i.e. zero rows).
  INSERT INTO mytable (field1, field2) VALUES ('21',  '123123');# 1 row(s) affected.
  </code></pre>
  
  <p>The lock didn't work and the insert did. Clearly not working correctly...what am I doing wrong? I've been pouring oer the MySQL docs and this seems like what they say to do...</p>