Search Results
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 ...
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 ...
https://dev.mysql.com/doc/connector-python/en/connector-python-reference.html
Currently, only the most useful modules, classes, and methods for end users are documented. Examples should be considered working for Python 2.7, and Python 3.1 and greater. They might also work for older versions (such as Python 2.4) unless they ...