6.9.2.32 MySQLConnection.set_client_flags() Method

Deprecation

This method has been deprecated as of 9.3.0. Use the property method Section 6.9.2.39, “MySQLConnection.client_flags Property” instead.

Syntax:

Press CTRL+C to copy
 
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. The flags argument can be either an integer or a sequence of valid client flag values (see Section 6.9.7, “constants.ClientFlag Class”).

If flags is a sequence, each item in the sequence sets the flag when the value is positive or unsets it when negative. For example, to unset LONG_FLAG and set the FOUND_ROWS flags:

Press CTRL+C to copy
 
>>> from mysql.connector.constants import ClientFlag
>>> cnx.set_client_flags([ClientFlag.FOUND_ROWS, -ClientFlag.LONG_FLAG])
>>> cnx.reconnect()

Note

Client flags are only set or used when connecting to the MySQL server. It is therefore necessary to reconnect after making changes.