title: MySQL - How to count all rows per table in one query
body: <p>Is there a way to query the DB to find out how many rows there are in all the tables?</p>
  
  <p>i.e.</p>
  
  <pre><code>table1 1234
  table2 222
  table3 7888
  </code></pre>
  
  <p>Hope you can advise</p>