title: python mysql select return only first row of table, not all
body: <p>im dealing with strage problem and this is like this:</p>
  
  <p>this query should return all of my table:</p>
  
  <pre><code>db = MySQLdb.connect(host="localhost", port=3306, user="A", passwd="B", db="X")
  cursor = db.cursor()
  cursor.execute("select * from mytable")
  cursor.fetchall()
  for row in cursor:
  print row
  </code></pre>
  
  <p>for loop should print all rows in cursor but it will only print the first one.
  it seems cursor is filled with first row only.</p>
  
  <p>is there anything that i missed here?
  thanks</p>