Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-select-db.html
Raises a MySQLInterfaceError exception for any MySQL error returned by the MySQL server. Syntax: ccnx.select_db(db_name) Sets the default (current) database for the current session.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-shutdown.html
Raises a TypeError exception if the first argument is not an integer. Raises a MySQLErrorInterface exception if an error is retured by the MySQL server. The only argument currently permitted is an integer that describes the shutdown type.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-stat.html
Raises a MySQLErrorInterface exception if an error is retured by the MySQL server. Syntax: info = ccnx.stat() Returns the server status as a string.
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-mysqlconnection-cmd-debug.html
Instructs the server to write debugging information to the error log.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-query.html
Syntax: cnx.cmd_query(statement) This method sends the given statement to the MySQL server and returns a result. The returned dictionary contains information depending on what kind of query was executed. If the query is a SELECT statement, the ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnectionpool-constructor.html
It is not an error for multiple pools to have the same name. Syntax: MySQLConnectionPool(pool_name=None, pool_size=5, pool_reset_session=True, **kwargs) This constructor instantiates an object that manages a connection pool. If this argument is not ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-fetchwarnings.html
The following example shows a SELECT statement that generates a warning: >>> cnx.get_warnings = True >>> cursor.execute("SELECT 'a'+1") >>> cursor.fetchall() [(1.0,)] >>> cursor.fetchwarnings() [(u'Warning', 1292, u"Truncated incorrect DOUBLE value: ...Syntax: tuples = cursor.fetchwarnings() This method returns a list of tuples containing warnings generated by the previously executed ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-warnings.html
The following example shows a SELECT statement that generates a warning: >>> cnx.get_warnings = True >>> cursor.execute("SELECT 'a'+1") >>> cursor.fetchall() [(1.0,)] >>> print(cursor.warnings) [(u'Warning', 1292, u"Truncated incorrect DOUBLE value: ... Syntax: tuples = cursor.warnings This property returns a list of tuples containing warnings generated by the previously executed ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
This dictionary is passed to the execute() method of the cursor object if an error occurred. Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage engine such as InnoDB (the ...