Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-excel.html
To address this issue, use the CONCAT() function in your queries. If you have problems importing data into Microsoft Excel, particularly numeric, date, and time values, this is probably because of a bug in Excel, where the column type of the source ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-visualbasic.html
This means that some queries like SHOW PROCESSLIST do not work properly. To be able to update a table, you must define a primary key for the table. The fix is to use OPTION=16384 in the ODBC connect string or to select the Change BIGINT columns to ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality.html
This section provides help with common queries and areas of functionality in MySQL and how to use them with Connector/ODBC.
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-errors-warning.html
Consider using either more strict Server SQL Modes or the raise_on_warnings connection argument to make Connector/Python raise errors when your queries produce warnings. This exception is used for reporting important warnings, however, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-can-consume-results.html
This property indicates the value of the consume_results connection parameter that controls whether result sets produced by queries are automatically read and discarded.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-init-db.html
In subsequent queries, this database is the default for table references that include no explicit database qualifier. Syntax: cnx.cmd_init_db(db_name) This method makes specified database the default (current) database.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-process-info.html
Instead, use the SHOW PROCESSLIST statement or query the tables found in the database INFORMATION_SCHEMA.