what is a mysql buffered cursor w.r.t python mysql connector : <p>Can someone please give an example to understand this?</p>

<blockquote>
  <p>After executing a query, a MySQLCursorBuffered cursor fetches the entire result set from the server and buffers the rows.
  For queries executed using a buffered cursor, row-fetching methods such as fetchone() return rows from the set of buffered rows. For nonbuffered cursors, rows are not fetched from the server until a row-fetching method is called. In this case, you must be sure to fetch all rows of the result set before executing any other statements on the same connection, or an InternalError (Unread result found) exception will be raised.</p>
</blockquote>

<p>Thanks</p>
