Search Results
https://dev.mysql.com/doc/connectors/en/connector-odbc-both-openssl.html
If Connector/ODBC is connecting securely with the MySQL server and the application using the connection makes calls itself to an OpenSSL library, the application might then fail, as two copies of the OpenSSL library will then be in use. Note ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-authentication.html
Connector/ODBC supports different authentication methods, including: Standard authentication using a MySQL username and password, such as caching_sha2_password. Support added in Connector/ODBC 8.0.26 for Linux clients, and 8.0.27 for Windows ...See ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-dsn-macos.html
To create a DSN using the myodbc-installer utility, you only need to specify the DSN type and the DSN connection string. For example: $> myodbc-installer -a -s -t"DSN=mydb;DRIVER=MySQL ODBC 9.3 Driver;SERVER=mysql;USER=username;PASSWORD=pass" To use ... To configure a DSN on macOS, you can either use the command-line utility (myodbc-installer), edit the odbc.ini file within the Library/ODBC directory of the user, or use the ODBC Administrator ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-microsoft.html
The majority of Microsoft applications have been tested with Connector/ODBC, including Microsoft Office, Microsoft Access and the various programming languages supported within ASP and Microsoft Visual Studio. 5.8.2.1.1 Microsoft Access To improve ...Include a TIMESTAMP column in all tables that you want to be able to ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnectionpool-constructor.html
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 given, Connector/Python automatically generates the name, ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnectionpool-set-config.html
Syntax: cnxpool.set_config(**kwargs) This method sets the configuration parameters for connections in the pool. Connections requested from the pool after the configuration change use the new parameters. Connections obtained before the change remain ...Example: dbconfig = { "database": "performance_schema", "user": "admin", "password": "password", } ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursorraw.html
To create a raw cursor, use the raw argument when calling a connection's cursor() method. Alternatively, to make all cursors created from the connection raw by default, use the raw connection argument. Example: import mysql.connector cnx = ...A ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-select.html
The following example shows how to query data using a cursor created using the connection's cursor() method. We then create a new cursor, by default a MySQLCursor object, using the connection's cursor() method. Connector/Python converts hire_start ...The task is to select all employees hired in the year 1999 and print their names and hire dates to the ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-transaction.html
Note The following example uses tables created in the example Section 6.5.2, “Creating Tables Using Connector/Python”. We then create a new cursor, by default a MySQLCursor object, using the connection's cursor() method. Since by default ...
https://dev.mysql.com/doc/connector-net/en/connector-net-faq.html
When a client begins a transaction in classic MySQL, all subsequent commands (on that connection) are part of that transaction until the client commits or rolls back the transaction. To execute a command outside of that transaction, you must open a ... Questions 10.1: Are all commands executed after a transaction begins automatically enlisted in the transaction? 10.2: How do I obtain the value of an auto-incremented column? Questions and Answers10.1: Are all commands executed after a transaction begins automatically enlisted in the transaction? ...