Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor.html
Cursor objects interact with the MySQL server using a MySQLConnection object. To create a cursor, use the cursor() method of a connection object: import mysql.connector cnx = mysql.connector.connect(database='world') cursor = cnx.cursor() Several ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-pooledmysqlconnection-config.html
For pooled connections, the config() method raises a PoolError exception. Configuration for pooled connections should be done using the pool object.
https://dev.mysql.com/doc/connectors/en/connector-python-api-pooledmysqlconnection-pool-name.html
Syntax: cnx.pool_name This property returns the name of the connection pool to which the connection belongs.
https://dev.mysql.com/doc/connectors/en/connector-python-api-sqlmode.html
It is mostly used when setting the SQL modes at connection time using the connection's sql_mode property.
https://dev.mysql.com/doc/connectors/en/connector-python-django-backend.html
Connector/Python includes a mysql.connector.django module that provides a Django back end for MySQL. When the Connector/Python back end does this, it arranges for the sql_mode system variable to be set to TRADITIONAL at startup. For example, ...
https://dev.mysql.com/doc/connectors/en/connector-python-introduction.html
MySQL Connector/Python enables Python programs to access MySQL databases, using an API that is compliant with the Python Database API Specification v2.0 (PEP 249). For notes detailing the changes in each release of Connector/Python, see MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-python-tutorial-cursorbuffered.html
The following example script gives a long-overdue 15% raise effective tomorrow to all employees who joined in the year 2000 and are still with the company. (A buffered cursor fetches and buffers the rows of a result set after executing a query; see ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-authentication-user-plugin.html
Advanced users with special security requirements can create their own authentication plugins for MySQL Connector/NET applications. /// </summary> /// <returns>An string with the user name</returns> /// <remarks>Default implementation returns the ...For background and usage information about MySQL authentication plugins, see Authentication Plugins and Writing Authentication ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-binary-issues.html
In these situations, it becomes practically impossible for the connector to be able to correctly identify the correct metadata. However, some existing applications may encounter issues with this change and can use a connection string option to ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-blob-writing.html
To write a file to a database, we need to convert the file to a byte array, then use the byte array as a parameter to an INSERT query. After assigning the byte array as a parameter of the MySqlCommand object, the ExecuteNonQuery method is called ...