Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-visualobjects.html
Select the Don't optimize column widths option. ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-vision.html
Select the Return matching rows option. ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-dynamic-cursor.html
Support for the dynamic cursor is provided in Connector/ODBC 3.51, but dynamic cursors are not enabled by default. You can enable this function within Windows by selecting the Enable Dynamic Cursor check box within the ODBC Data Source ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-convert-to-mysql.html
Syntax: converted_obj = ccnx.convert_to_mysql(obj)) Converts a Python object to a MySQL value based on the Python type of the object. ccnx.query('SELECT CURRENT_USER(), 1 + 3, NOW()') row = ccnx.fetch_row() for col in row: ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-fetch-fields.html
Syntax: field_info = ccnx.fetch_fields() Fetches column information for the active result set. Returns a list of tuples, one tuple per column Raises a MySQLInterfaceError exception for any MySQL error returned by the MySQL server.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-fetch-row.html
Syntax: row = ccnx.fetch_row() Fetches the next row from the active result set. The row is returned as a tuple that contains the values converted to Python objects, unless raw was set. ccnx.query('SELECT CURRENT_USER(), 1 + 3, NOW()') row = ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-query.html
ccnx.query('DROP TABLE IF EXISTS t') ccnx.query('CREATE TABLE t (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY)') ccnx.query('INSERT INTO t (i) VALUES (NULL),(NULL),(NULL)') ccnx.query('SELECT LAST_INSERT_ID()') row = ccnx.fetch_row() ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-error.html
This exception is the base class for all other exceptions in the errors module. It can be used to catch all errors in a single except statement. errors.Error is internally used by Connector/Python to raise MySQL client and server errors and should ...
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-query.html
Syntax: cnx.cmd_query(statement) This method sends the given statement to the MySQL server and returns a result. The returned dictionary contains information depending on what kind of query was executed. If the query is a SELECT statement, the ...