Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-introduction.html
The MySQL Connector/ODBC is the name for the family of MySQL ODBC drivers (previously called MyODBC drivers) that provide access to a MySQL database using the industry standard Open Database Connectivity (ODBC) API. This reference covers ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-support-version-history.html
Connector/ODBC 8.0: added MySQL Server 8.0 support, including caching_sha2_password and the related GET_SERVER_PUBLIC_KEY connection attribute. It conforms to the ODBC 3.8 specification and contains key ODBC 3.8 features including ... This section ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-borland-cppbuilder.html
BDE, however, does not seem to recognize primary keys, only the index named PRIMARY, although this has not been a problem. The only known problem is that when the table schema changes, query fields are not updated.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html
Include a primary key in each MySQL table you want to use with Access. To improve the integration between Microsoft Access and MySQL through Connector/ODBC: For all versions of Access, enable the Connector/ODBC Return matching rows option. Include ...
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-character-set-info.html
The returned dictionary has the keys number, name, csname, comment, dir, mbminlen, and mbmaxlen. Syntax: info = ccnx.get_character_set_info() Returns information about the default character set for the current MySQL session.
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-custom-error-exception.html
The error argument can be a dictionary, in which case the key is the server error number, and value the class of the exception to be raised. Syntax: errors.custom_error_exception(error=None, exception=None) This method defines custom exceptions for ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-programmingerror.html
The following example shows how to handle syntax errors: try: cursor.execute("CREATE DESK t1 (id int, PRIMARY KEY (id))") except mysql.connector.ProgrammingError as err: if err.errno == errorcode.ER_SYNTAX_ERROR: print("Check your syntax!") else: ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-column-names.html
Syntax: sequence = cursor.column_names This read-only property returns the column names of a result set as sequence of Unicode strings.