Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-fetchwarnings.html
To set whether to fetch warnings, use the connection's get_warnings property. The following example shows a SELECT statement that generates a warning: >>> cnx.get_warnings = True >>> cursor.execute("SELECT 'a'+1") >>> cursor.fetchall() [(1.0,)] >>> ...Syntax: tuples = cursor.fetchwarnings() This method returns a list of tuples containing warnings generated by the previously executed ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-warnings.html
To set whether to fetch warnings, use the connection's get_warnings property. The following example shows a SELECT statement that generates a warning: >>> cnx.get_warnings = True >>> cursor.execute("SELECT 'a'+1") >>> cursor.fetchall() [(1.0,)] >>> ... Syntax: tuples = cursor.warnings This property returns a list of tuples containing warnings generated by the previously executed ...
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 ...