Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-get-rows.html
Syntax: cnx.get_rows(count=None) This method retrieves all or remaining rows of a query result set, returning a tuple containing the rows as sequences and the EOF packet information. The count argument can be used to obtain a given number of rows.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-get-warnings.html
This property can be assigned a value of True or False to enable or disable whether warnings should be fetched automatically. The property can be invoked to retrieve the current warnings setting. >>> cnx.get_warnings = True >>> ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-raise-on-warnings.html
This property can be assigned a value of True or False to enable or disable whether warnings should raise exceptions. The property can be invoked to retrieve the current exceptions setting. Setting raise_on_warnings also sets get_warnings because ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-clear-attributes.html
Syntax: cursor.clear_attributes() Clear the list of query attributes on the connector's side, as set by Section 10.5.2, “MySQLCursor.add_attribute() Method”.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-execute.html
Syntax: cursor.execute(operation, params=None) iterator = cursor.execute(operation, params=None) # Allowed before 9.2.0 iterator = cursor.execute(operation, params=None, multi=True) This method executes the given database operation (query or ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-executemany.html
Syntax: cursor.executemany(operation, seq_of_params) This method prepares a database operation (query or command) and executes it against all parameter sequences or mappings found in the sequence seq_of_params. Note In Python, a tuple containing a ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-get-attributes.html
Syntax: cursor.get_attributes() Return a list of existing query attributes, as set by Section 10.5.2, “MySQLCursor.add_attribute() Method”.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-rowcount.html
Syntax: count = cursor.rowcount This read-only property returns the number of rows returned for SELECT statements, or the number of rows affected by DML statements such as INSERT or UPDATE. For nonbuffered cursors, the row count cannot be known ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursorbuffereddict.html
A MySQLCursorBufferedDict cursor is like a MySQLCursorDict cursor, but is buffered: After executing a query, it fetches the entire result set from the server and buffers the rows. For information about the implications of buffering, see Section ...
https://dev.mysql.com/doc/connector-python/en/connector-python-cext-module.html
To use the C Extension directly, import the _mysql_connector module rather than mysql.connector, then use the _mysql_connector.MySQL() class to obtain a MySQL instance. For example: import _mysql_connector ccnx = _mysql_connector.MySQL() ...