title: How to update multiple tables by single mysql query?
body: <p>I have two tables tb1 &amp; tb2
  I have to update a common column of both tables, i.e user_level
  I have a common criteria for both tables like username.</p>
  
  <p>So I want to update like this:</p>
  
  <pre><code>UPDATE tb1, tb2 SET user_level=1 WHERE username="Mr.X"
  </code></pre>
  
  <p>But somehow it is not working.
  What would be the correct mysql query for this?</p>