Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-client-flags.html
Syntax: >>> cnx.client_flags=flags >>> cnx.clieng_flags This property sets the client flags to use when connecting to the MySQL server, and returns the set value as an integer. For example, to unset LONG_FLAG and set the FOUND_ROWS flags: >>> from ...The flags value can be either an integer or a sequence of valid client flag values (see Section 10.7, “constants.ClientFlag ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-collation.html
This property returns a string indicating which collation is used for the connection, whether or not it is connected.
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.