Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-refresh.html
This method flushes tables or caches, or resets replication server information. The options argument should be a bitmask value constructed using constants from the constants.RefreshOption class. Example: >>> from mysql.connector import RefreshOption ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-commit.html
This method sends a COMMIT statement to the MySQL server, committing the current transaction. Since by default Connector/Python does not autocommit, it is important to call this method after every transaction that modifies data for tables that use ...
https://dev.mysql.com/doc/connectors/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/connectors/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/connectors/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/connectors/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/connectors/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/connectors/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/connectors/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/connectors/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 ...