title: MYSQL - count number of rows in each table
body: <p>I would like to know how many rows are in each table in my database. I've come so far as to having</p>
  
  <pre><code>select count(*) _tablename_; 
  </code></pre>
  
  <p>However i would need to do that on each and every table - and there are a lot. What would me the best way to get a print-out with the table name and it's row count? </p>