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
You can enable this function within Windows by selecting the Enable Dynamic Cursor check box within the ODBC Data Source Administrator. Support for the dynamic cursor is provided in Connector/ODBC 3.51, but dynamic cursors are not enabled by ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-convert-to-mysql.html
ccnx.query('SELECT CURRENT_USER(), 1 + 3, NOW()') row = ccnx.fetch_row() for col in row: print(ccnx.convert_to_mysql(col)) ccnx.consume_result() Raises a MySQLInterfaceError exception if the Python object cannot be converted. Syntax: converted_obj ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-fetch-fields.html
ccnx.query('SELECT CURRENT_USER(), 1 + 3, NOW()') field_info = ccnx.fetch_fields() for fi in field_info: print(fi) ccnx.consume_result() . Syntax: field_info = ccnx.fetch_fields() Fetches column information for the active result set. Returns a list ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-fetch-row.html
ccnx.query('SELECT CURRENT_USER(), 1 + 3, NOW()') row = ccnx.fetch_row() print(row) ccnx.free_result() Raises a MySQLInterfaceError exception for any MySQL error returned by the MySQL server. Syntax: row = ccnx.fetch_row() Fetches the next row from ...
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() ...raw_as_string ...
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
If the query is a SELECT statement, the result contains information about columns. Syntax: cnx.cmd_query(statement) This method sends the given statement to the MySQL server and returns a result. The returned dictionary contains information ...