MySQL Connector/Python Developer Guide

11.16 _mysql_connector.MySQL.fetch_row() Method

Syntax:

row = ccnx.fetch_row()

Fetches the next row from the active result set. The row is returned as a tuple that contains the values converted to Python objects, unless raw was set.

ccnx.query('SELECT CURRENT_USER(), 1 + 3, NOW()')
row = ccnx.fetch_row()
print(row)
ccnx.free_result()

Raises a MySQLInterfaceError exception for any MySQL error returned by the MySQL server.