title: Query to find the count of all the tables in a MySQL database
body: <p>We have been using the following query to find the size (i.e. row count) of all the tables in a database:</p>
  <pre><code>SELECT TABLE_NAME, TABLE_ROWS FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'my_database_name';
  </code></pre>
  <p>However, we found out today that it does not give the accurate count, but only an approximate count (especially if there is a big disparity in the row count of different tables).</p>
  <hr />
  <p><strong>Question:</strong> What is the correct query to find the number of rows in all the tables of a database?</p>