Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-debug.html
Instructs the server to write debugging information to the error log.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-refresh.html
This method flushes tables or caches, or resets replication server information. The options argument should be a bitmask value constructed using constants from the constants.RefreshOption class. Example: >>> from mysql.connector import RefreshOption ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-shutdown.html
Deprecation This MySQL Server functionality is deprecated. Asks the database server to shut down. The connected user must have the SHUTDOWN privilege. Returns a dictionary containing the OK packet information. ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-connect.html
Example: cnx = MySQLConnection(user='joe', database='test') For a connection obtained from a conection pool, the connection object class is PooledMySQLConnection. Syntax: MySQLConnection.connect(**kwargs) This method sets up a connection, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-reset-session.html
Syntax: cnx.reset_session(user_variables = None, session_variables = None) Resets the connection by reauthenticating to clear the session state. user_variables, if given, is a dictionary of user variable names and values. Example: user_variables = ...session_variables, if given, is a dictionary of system variable names and ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnectionpool-set-config.html
Example: dbconfig = { "database": "performance_schema", "user": "admin", "password": "password", } cnxpool.set_config(**dbconfig) . Syntax: cnxpool.set_config(**kwargs) This method sets the configuration parameters for connections in the pool.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-with-rows.html
Syntax: boolean = cursor.with_rows This read-only property returns True or False to indicate whether the most recently executed operation could have produced rows. The with_rows property is useful when it is necessary to determine whether a ...
https://dev.mysql.com/doc/connector-python/en/connector-python-cext-development.html
If the C extension is not available on the system then use_pure is True. On Linux, the C and Python implementations are available as different packages. You can install one or both implementations on the same system. For Connector/Python ...
https://dev.mysql.com/doc/connector-python/en/connector-python-cext-module.html
For example: import _mysql_connector ccnx = _mysql_connector.MySQL() ccnx.connect(user='scott', password='password', host='127.0.0.1', database='employees') ccnx.query("SHOW VARIABLES LIKE 'version%'") row = ccnx.fetch_row() while row: print(row) ...
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. This back end supports new features found as of MySQL 5.6 such as fractional seconds support for temporal data types. Django Configuration Django ...