Search Results
https://dev.mysql.com/doc/connectors/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 ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-prepared.html
To prepare a statement, use the following sequence of steps: Create a MySqlCommand object and set the CommandText property to your query. Prepared statements can provide significant performance improvements on queries that are executed more than ...
https://dev.mysql.com/doc/connectors/en/connector-net-ref-entityframework.html
Classes Class Description BackoffAlgorithm Represents the base class for backoff algorithms. BackoffAlgorithmErr1040 Backoff algorithm customized for the MySQL error code 1040 - Too many connections. BackoffAlgorithmErr1205 Backoff algorithm ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-both-openssl.html
When creating a build of Connector/ODBC that links (statically or dynamically) to a version of the libmysqlclient library that is in turn statically linked to an OpenSSL library, do NOT export OpenSSL symbols in your build. If Connector/ODBC is ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-access-export.html
To define a new DSN for Connector/ODBC instead, click New and follow the instructions in Section 5.5.3, “Configuring a Connector/ODBC DSN on Windows”; double click the new DSN after it has been created. Important Make sure that the information ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-access-import.html
To define a new DSN for Connector/ODBC instead, click New and follow the instructions in Section 5.5.3, “Configuring a Connector/ODBC DSN on Windows”; double click the new DSN after it has been created. To import tables from MySQL to Access, ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-installation-source-windows.html
You only need to build Connector/ODBC from source on Windows to modify the source or installation location. If you are unsure whether to install from source, please use the binary installation detailed in Section 5.4.1, “Installing Connector/ODBC ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-functionality-dynamic-cursor.html
On other platforms, you can enable the dynamic cursor by adding 32 to the OPTION value when creating the DSN. Support for the dynamic cursor is provided in Connector/ODBC 3.51, but dynamic cursors are not enabled by default. You can enable this ...
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: ...