Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errorcode.html
This module contains both MySQL server and client error codes defined as module attributes with the error number as value. Using error codes instead of error numbers could make reading the source code a bit easier. >>> from mysql.connector import ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-client-flags.html
Syntax: >>> cnx.client_flags=flags >>> cnx.clieng_flags This property sets the client flags to use when connecting to the MySQL server, and returns the set value as an integer. The flags value can be either an integer or a sequence of valid client ...
https://dev.mysql.com/doc/connector-python/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/connector-python/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/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 ...