title: Retrieving Data from MySQL in batches via Python
body: <p>I would like to make this process in batches, because of the volume. </p>
  
  <p>Here's my code:</p>
  
  <pre><code> getconn = conexiones()
   con = getconn.mysqlDWconnect()
   with con:
       cur = con.cursor(mdb.cursors.DictCursor)
       cur.execute("SELECT id, date, product_id, sales FROM sales")
       rows = cur.fetchall()
  </code></pre>
  
  <p>How can I implement an index to fetch the data in batches?</p>