title: How to check specific table is locked in Mysql?
body: <p>I am executing below query to find the whether my temp table is locked.</p>
  
  <pre><code>show open tables where in_use &gt; 0 and table = 'temp'
  </code></pre>
  
  <p>But it throwing below error : </p>
  
  <blockquote>
    <p>Syntax error near 'table = 'temp'</p>
  </blockquote>
  
  <p>I have searched but unable to get the correct syntax. Can anybody help.</p>