Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-integrityerror.html
The following example shows a duplicate key error raised as IntegrityError: cursor.execute("CREATE TABLE t1 (id int, PRIMARY KEY (id))") try: cursor.execute("INSERT INTO t1 (id) VALUES (1)") cursor.execute("INSERT INTO t1 (id) VALUES (1)") except ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-programmingerror.html
The following example shows how to handle syntax errors: try: cursor.execute("CREATE DESK t1 (id int, PRIMARY KEY (id))") except mysql.connector.ProgrammingError as err: if err.errno == errorcode.ER_SYNTAX_ERROR: print("Check your syntax!") else: ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnectionpool-add-connection.html
If this argument is missing, the pool creates a new connection and adds it. Syntax: cnxpool.add_connection(cnx = None) This method adds a new or existing MySQLConnection to the pool, or raises a PoolError if the pool is full. Arguments: cnx: The ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-column-names.html
Syntax: sequence = cursor.column_names This read-only property returns the column names of a result set as sequence of Unicode strings.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-constructor.html
If omitted, the cursor is created but its execute() method raises an exception.
https://dev.mysql.com/doc/connectors/en/connector-python-versions.html
Python terminology regarding distributions: Built Distribution: A package created in the native packaging format intended for a given platform. This section describes both version releases, such as 8.0.34, along with notes specific to the two ...
https://dev.mysql.com/doc/connectors/en/differences-between-binary-and-source-distribution.html
Note Creating a wheel package from an sdist may fail for some older Python version, as the Connector/Python source code is only compatible with a specific subset of Python versions. Installing from a wheel (bdist package) is the recommended, except ...
https://dev.mysql.com/doc/connector-net/en/connector-net-connections.html
Even when using the MySqlHelper class, a MySqlConnection object is created by the helper class. All interaction between a .NET application and the MySQL server is routed through a MySqlConnection object when using the classic MySQL protocol. Before ...
https://dev.mysql.com/doc/connector-net/en/connector-net-medium-trust-evolution.html
The partial trust support for MySQL Connector/NET has improved rapidly throughout the 6.5.x and 6.6.x versions. The latest enhancements do require some configuration changes in existing deployments. If the library is not in the GAC, the only ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-datetime-fractional.html
To use the more precise date and time types, specify a value from 1 to 6 when creating the table column, for example TIME(3) or DATETIME(6), representing the number of digits of precision after the decimal point. MySQL Connector/NET supports the ...