title: loop over all tables in mysql databases
body: <p>I am new with MySQL and I need some help please. I am using MySQL connector to write scripts.</p>
  
  <p>I have database contain 7K tables and I am trying to select some values from some of these tables </p>
  
  <pre><code>cursor.execute( "SELECT SUM(VOLUME) FROM stat_20030103 WHERE company ='Apple'")
  for (Volume,) in cursor:
  print(Volume)
  </code></pre>
  
  <p>This works for one table e.g (stats_20030103). However I want to sum all volume of all tables .startwith (stats_2016) where the company name is Apple. How I can loop over my tables?</p>