Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-excel.html
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 data is used to determine the data type when that data is ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-visualbasic.html
To be able to update a table, you must define a primary key for the table. This means that some queries like SHOW PROCESSLIST do not work properly. 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-python/en/connector-python-api-cext-get-client-info.html
Syntax: info = ccnx.get_client_info() Returns the MySQL client library version as a string.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-get-host-info.html
Syntax: info = ccnx.get_host_info() Returns a description of the type of connection in use as a string.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-get-server-info.html
Syntax: info = ccnx.get_server_info() Returns the MySQL server version as a string.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-next-result.html
Syntax: ccnx.next_result() Initiates the next result set for a statement string that produced multiple result sets. 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-set-character-set.html
Syntax: ccnx.set_character_set(charset_name) Sets the default character set for the current session. The only argument permitted is a string that contains the character set name. Raises a TypeError exception if the argument is not a PyString_type.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-stat.html
Syntax: info = ccnx.stat() Returns the server status as a string. Raises a MySQLErrorInterface exception if an error is retured by the MySQL server.
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 ...