row = cursor.fetchone()
This method retrieves the next row of a query result set and
returns a single sequence, or
None 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; see
Section 10.6.2, “Class cursor.MySQLCursorRaw”.
The following example shows two equivalent ways to process a
query result. The first uses
fetchone() in a
while loop, the second uses the cursor as an
# Using a while loop cursor.execute("SELECT * FROM employees") row = cursor.fetchone() while row is not None: print(row) row = cursor.fetchone() # Using the cursor as iterator cursor.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.