Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-ado.html
When you are coding with the ADO API and Connector/ODBC, you need to pay attention to some default properties that aren't supported by the MySQL server. For example, using the CursorLocation Property as adUseServer returns a result of −1 for the ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes.html
The notes provided here are based on the experiences of Connector/ODBC developers and users. Here are some common notes and tips for using Connector/ODBC within different environments, applications and tools.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-mysql.html
import _mysql_connector ccnx = _mysql_connector.MySQL() ccnx.connect(user='scott', password='password', host='127.0.0.1', database='employees') ccnx.close() Permitted arguments for the MySQL class are auth_plugin, buffered, charset_name, ... Syntax: ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-reset-connection.html
Syntax: ccnx.reset_connection() Resets the user variables and session variables for a connection session.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-fieldtype.html
This class provides all supported MySQL field or data types. They can be useful when dealing with raw data or defining your own converters. The field type is stored with every cursor in the description for each column. The following example shows ...
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 ...