title: Python MySQLdb doesn't return all the data from the database
body: <p>I'm using the Python package <code>MySQLdb</code> to fetch data from a MySQL database.  However, I notice that I can't fetch the entirety of the data. </p>
  
  <pre><code>import MySQLdb
  db = MySQLdb.connect(host=host, user=user, passwd=password)
  
  cur = db.cursor()
  
  query = "SELECT count(*) FROM table"
  cur.execute(query)
  </code></pre>
  
  <p>This returns a number less than what I get if I execute the exact same query in MySQL Workbench.  I've noticed that the data it doesn't return is the data that was inserted into the database most recently.  Where am I going wrong?</p>