Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-connect.html
Syntax: MySQLConnection.connect(**kwargs) This method sets up a connection, establishing a session with the MySQL server. If no arguments are given, it uses the already configured or default values. For a complete list of possible arguments, see ...
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-mysqlconnection-rollback.html
This method sends a ROLLBACK statement to the MySQL server, undoing all data changes from the current transaction. By default, Connector/Python does not autocommit, so it is possible to cancel transactions when using transactional storage engines ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-set-client-flags.html
Syntax: cnx.set_client_flags(flags) This method sets the client flags to use when connecting to the MySQL server, and returns the new value as an integer. The flags argument can be either an integer or a sequence of valid client flag values (see ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-add-attribute.html
Syntax: cursor.add_attribute(name, value) Adds a new named query attribute to the list, as part of MySQL server's Query Attributes functionality. name: The name must be a string, but no other validation checks are made; attributes are sent as is to ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-callproc.html
Syntax: result_args = cursor.callproc(proc_name, args=()) This method calls the stored procedure named by the proc_name argument. The args sequence of parameters must contain one entry for each argument that the procedure expects. Result sets ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-column-names.html
Syntax: sequence = cursor.column_names This read-only property returns the column names of a result set as sequence of Unicode strings.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-description.html
Syntax: tuples = cursor.description This read-only property returns a list of tuples describing the columns in a result set. Each tuple in the list contains values as follows: (column_name, type, None, None, None, None, null_ok, column_flags) The ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-fetchone.html
Syntax: 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 ...
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 ...