MySQL :: MySQL Connector/Python Developer Guide :: 11.15 _mysql_connector.MySQL.fetch

MySQL Connector/Python Developer Guide / Connector/Python C Extension API Reference / _mysql_connector.MySQL.fetch_fields() Method

11.15 _mysql_connector.MySQL.fetch_fields() Method

Syntax:

Press CTRL+C to copy
 
field_info = ccnx.fetch_fields()

Fetches column information for the active result set. Returns a list of tuples, one tuple per column

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

Press CTRL+C to copy
 
ccnx.query('SELECT CURRENT_USER(), 1 + 3, NOW()')
field_info = ccnx.fetch_fields()
for fi in field_info:
  print(fi)
ccnx.consume_result()

PREV HOME UP NEXT