Syntax:
row = cursor.fetchone() This method retrieves the next row of a query result set and returns a single sequence, orNone if no more rows are available. By default, the returned tuple consists of data returned by the MySQL server, converted to Python objects. If the cursor is a raw cursor, no such conversion occurs; seeSection 10.6.2, “cursor.MySQLCursorRaw Class”.
Thefetchone() method is used byfetchall() andfetchmany(). It is also used when a cursor is used as an iterator.
The following example shows two equivalent ways to process a query result. The first usesfetchone() in awhile loop, the second uses the cursor as an iterator:
# Using a while loopcursor.execute("SELECT * FROM employees")row = cursor.fetchone()while row is not None: print(row) row = cursor.fetchone()# Using the cursor as iteratorcursor.execute("SELECT * FROM employees")for row in cursor: print(row)You must fetch all rows for the current query before executing new statements using the same connection.