title: Mysql - Table lock error
body: <p>I am experiencing some problems with table locking. I have locked certain number of table in transaction. <code>LOCK TABLES t1 READ, t2 READ, t3 READ, t4 READ,t5 READ,t6 READ,t7 READ;</code></p>
  
  <p>While reading its ok, but when I am trying to write/update to this tables it's showing the error <strong>Table 't1' was locked with a READ lock and can't be updated</strong> </p>
  
  <p>But I never locked the table for write, I have to write to these tables with updated values.</p>
  
  <p>My aim is I need to select and I need to update rows, while others should not interact with above tables until the process finished.</p>
  
  <p>Much appreciated your solutions!</p>