Search Results
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? ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-asp-roles.html
Currently, MySQL Connector/NET includes web providers for membership (or simple membership), roles, profiles, session state, site map, and web personalization. This tutorial shows you how to set up your ASP.NET web application to use the ... Many ...
https://dev.mysql.com/doc/connector-net/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/connector-odbc/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/connector-odbc/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/connector-odbc/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.4 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/connector-python/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/connector-python/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/connector-python/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/connector-python/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 ...