title: AttributeError: 'Connection' object has no attribute 'fetchall'
body: <p>What am I doing wrong here?</p>
  
  <pre><code>engine_str = 'mysql+mysqlconnector://my_username:my_pass@localhost/my_db'
  engine = sqlalchemy.create_engine(engine_str, echo=False, encoding='utf-8')
  connection = engine.connect()
  query = "SELECT * from history_table"
  
  connection.execute(query)
  rows = connection.fetchall()
  </code></pre>
  
  <h2>Error</h2>
  
  <pre><code>AttributeError: 'Connection' object has no attribute 'fetchall'
  </code></pre>