Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-set-client-flags.html
Syntax: cnx.set_client_flags(flags) This method sets the client flags to use when connecting to the MySQL server, and returns the new value as an integer. For example, to unset LONG_FLAG and set the FOUND_ROWS flags: >>> from ...The flags argument ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-shutdown.html
Unlike disconnect(), shutdown() closes the client connection without attempting to send a QUIT command to the server first. Thus, it will not block if the connection is disrupted for some reason such as network failure.
https://dev.mysql.com/doc/connector-python/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/connector-python/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/connector-python/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/connector-python/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/connector-python/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/connector-python/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/connector-python/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/connector-python/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 ...