Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-statistics.html
Returns a dictionary containing information about the MySQL server including uptime in seconds and the number of running threads, questions, reloads, and open tables.
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-connected.html
This read-only property checks whether the connection to MySQL is available using the ping() method; but unlike ping(), connected returns True when the connection is available, and False otherwise.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-constructor.html
Syntax: cnx = MySQLConnection(**kwargs) The MySQLConnection constructor initializes the attributes and when at least one argument is passed, it tries to connect to the MySQL server. For a complete list of arguments, see Section 7.1, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cursor.html
Arguments may be passed to the cursor() method to control what type of cursor to create: If buffered is True, the cursor fetches all rows from the server after an operation is executed. Syntax: cursor = cnx.cursor([arg=value[, arg=value]...]) This ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-is-connected.html
This method checks whether the connection to MySQL is available using the ping() method, but unlike ping(), is_connected() returns True when the connection is available, False otherwise.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-raise-on-warnings.html
Note You might always want to set the SQL mode if you would like to have the MySQL server directly report warnings as errors (see Section 10.2.52, “MySQLConnection.sql_mode Property”). This property can be assigned a value of True or False to ...
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-shutdown.html
Unlike disconnect(), shutdown() closes the client connection without attempting to send a QUIT command to the server first. Thus, it will not block if the connection is disrupted for some reason such as network failure.