Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cursor.html
Syntax: cursor = cnx.cursor([arg=value[, arg=value]...]) This method returns a MySQLCursor() object, or a subclass of it depending on the passed arguments. For more information about cursor objects, see Section 10.5, “cursor.MySQLCursor Class”, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-get-row.html
This method retrieves the next row of a query result set, returning a tuple. The tuple returned by get_row() consists of: The row as a tuple containing byte objects, or None when no more rows are available. EOF packet information as a dictionary ...
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 ...