Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-warning-count.html
Syntax: count = ccnx.warning_count() Returns the number of errors, warnings, and notes produced by the previous SQL statement.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-notsupportederror.html
It is also raised when using functions or statements that are not supported by stored routines. This exception is raised when some feature was used that is not supported by the version of MySQL that returned the error.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-process-info.html
Instead, use the SHOW PROCESSLIST statement or query the tables found in the database INFORMATION_SCHEMA.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-process-kill.html
Although still available, it is better to use the KILL SQL statement. The following two lines have the same effect: >>> cnx.cmd_process_kill(123) >>> cnx.cmd_query('KILL 123') .
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-cursor.html
If prepared is True, the cursor is used for executing prepared statements. 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 ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-database.html
This property sets the current (default) database by executing a USE statement. The property can also be used to retrieve the current database name. >>> cnx.database = 'test' >>> cnx.database = 'mysql' >>> cnx.database u'mysql' Returns a string.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-in-transaction.html
The value is True regardless of whether you start a transaction using the start_transaction() API call or by directly executing an SQL statement such as START TRANSACTION or BEGIN. This property returns True or False to indicate whether a ...
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.html
It also used to send commands and SQL statements and read the results. The MySQLConnection class is used to open and manage a connection to a MySQL server.