title: select data from mysql with mysql-connector-python
body: <p>I have a mysql db that I manage via MAMP (using port 3306, server is on port 80). I have downloaded and installed the mysql-connector-python library from Oracle and am trying to access and manipulate the db.  Curiously, following the tutorials at <a href="http://dev.mysql.com/doc/connector-python/en/connector-python-tutorial-cursorbuffered.html" rel="nofollow">http://dev.mysql.com/doc/connector-python/en/connector-python-tutorial-cursorbuffered.html</a>, I'm able to run a query to insert new records into a specific table (as long as I issue the .commit() method on my connector).</p>
  
  <p>However, I can't seem to retrieve any data with a simple select command.  So the query, "Select * from <code>Assignments</code>" returns None.</p>
  
  <pre><code>query = ('''SELECT title,description FROM  `Assignments` LIMIT 0 , 30''')
  
  cursor = cnx.cursor()
  result = cursor.execute(query)
  print "result:",result
  
  #All assignment info
  for (title, description) in results:
      print title, description
  </code></pre>
  
  <p>I keep getting the error, "TypeError: 'NoneType' object is not iterable".  I believe this has to do with the fact that the result of the executed query is None.  B/c I'm able to commit update and insert changes to the db, I know that I'm connecting just fine.  Why can't I run a simple SELECT command and get something?</p>