Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-clientflag.html
This class provides constants defining MySQL client flags that can be used when the connection is established to configure the session. >>> import mysql.connector >>> mysql.connector.ClientFlag.FOUND_ROWS 2 See Section 6.9.2.32, ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-autocommit.html
This property can be assigned a value of True or False to enable or disable the autocommit feature of MySQL. The property can be invoked to retrieve the current autocommit setting. When the autocommit is turned off, you must commit transactions ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-can-consume-results.html
This property indicates the value of the consume_results connection parameter that controls whether result sets produced by queries are automatically read and discarded.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-charset.html
This property returns a string indicating which character set is used for the connection, whether or not it is connected.
https://dev.mysql.com/doc/connectors/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 6.9.7, “constants.ClientFlag ...
https://dev.mysql.com/doc/connectors/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/connectors/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/connectors/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/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 ...