Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-sql-command.html
When a connection has been established with the MySQL database, the next step enables you to perform database operations. This task can be achieved through the use of the MySqlCommand object. After it has been created, there are three main methods ...
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 ...