Search Results
https://dev.mysql.com/doc/connectors/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/connectors/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/connectors/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/connectors/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/connectors/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 ...
https://dev.mysql.com/doc/connectors/en/connector-python-option-files.html
The resulting connection uses cpyapp_dev as the default database, not cpyapp: cnx2 = mysql.connector.connect(option_files='/etc/mysql/connectors.cnf', database='cpyapp_dev') Connector/Python raises a ValueError if an option file cannot be read, or ...(For general information about option files in MySQL, see Using Option Files.) Two arguments for the connect() call control use of option files in Connector/Python programs: option_files: Which option files to ...
https://dev.mysql.com/doc/connectors/en/connector-python-reference.html
mysql.connector errorcode errors connection constants conversion cursor dbapi locales eng client_error protocol utils . Examples should be considered working for Python 2.7, and Python 3.1 and greater. They might also work for older versions (such ...
https://dev.mysql.com/doc/connector-net/en/connector-net-authentication.html
Potential error conditions include: Private key could not be found at location given by OCI configuration entry 'key_file'. MySQL Connector/NET implements a variety of authentication plugins that MySQL Server can invoke to authenticate a user.
https://dev.mysql.com/doc/connector-net/en/connector-net-interceptors.html
This technique applies to exceptions raised at the SQL level, not to lower-level system or I/O errors. An interceptor is a software design pattern that provides a transparent way to extend or modify some aspect of a program, similar to a user exit.
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-mysqlcommand.html
If you send query attribute metadata to a server that does not support query attributes, the attempt is logged by the connector but no error is emitted. The MySqlCommand class represents a SQL statement to execute against a MySQL database. Class ...