Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-start-transaction.html
If readonly is omitted, the server's default access mode is used. If the server is older than MySQL 5.6.5, it does not support setting the access mode and Connector/Python raises a ValueError. Invoking start_transaction() raises a ProgrammingError ...It accepts arguments indicating whether to use a consistent snapshot, which transaction isolation level to use, and the transaction access mode: cnx.start_transaction(consistent_snapshot=bool, isolation_level=level, readonly=access_mode) The default consistent_snapshot value is ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursorbuffered.html
After executing a query, a MySQLCursorBuffered cursor fetches the entire result set from the server and buffers the rows. For nonbuffered cursors, rows are not fetched from the server until a row-fetching method is called. For queries executed using ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursorprepared.html
The MySQL client/server protocol has an option to send prepared statement parameters via the COM_STMT_SEND_LONG_DATA command. In MySQL, there are two ways to execute a prepared statement: Use the PREPARE and EXECUTE statements. To repeatedly execute ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-refreshoption.html
RefreshOption.REPLICA On a replica replication server, reset the source server information and restart the replica, like RESET SLAVE.
https://dev.mysql.com/doc/connectors/en/connector-python-django-backend.html
For example, support for fractional seconds precision is enabled when connecting to a server from MySQL 5.6.4 or higher. Connector/Python includes a mysql.connector.django module that provides a Django back end for MySQL. This back end supports new ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-connecting.html
The connect() constructor creates a connection to the MySQL server and returns a MySQLConnection object. The following example shows how to connect to the MySQL server: import mysql.connector cnx = mysql.connector.connect(user='scott', ...This can ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-select.html
After executing the query, the MySQL server is ready to send the data. The following example shows how to query data using a cursor created using the connection's cursor() method. The task is to select all employees hired in the year 1999 and print ...
https://dev.mysql.com/doc/connector-net/en/connector-net-asp-provider.html
At time of writing, the MySqlSessionStateStore is not added to machine.config at install time, and so add the following: <sessionState> <providers> <add name="MySqlSessionStateStore" type="MySql.Web.SessionState.MySqlSessionStateStore, MySql.Web, ...
https://dev.mysql.com/doc/connector-net/en/connector-net-connections.html
All interaction between a .NET application and the MySQL server is routed through a MySqlConnection object when using the classic MySQL protocol. Before your application can interact with the server, it must instantiate, configure, and open a ...
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core.html
optionsBuilder.UseMySQL("server=localhost;database=library;user=user;password=password"); } Limitations The Connector/NET implementation of EF Core has the following limitations: Memory-Optimized Tables is not supported. MySQL Connector/NET ...