Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-data-adapter.html
The application was built using the Microsoft Visual Studio to place and create the user interface controls, but the main code that uses the key classes described previously is shown in the next code example, and is portable. Previously, when using ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-mysqlscript.html
Commands for the mysql Command-Line Client are given here: CREATE DATABASE TestDB; USE TestDB; CREATE TABLE TestTable (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100)); The main method of the MySqlScript class is the Execute method.
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-ssl-pfx.html
openssl pkcs12 -export -in client-cert.pem -inkey client-key.pem -certfile cacert.pem -out client.pfx When asked for an export password, enter the password “pass”. Instead, Windows includes a certificate store that provides platform-dependent ...
https://dev.mysql.com/doc/connectors/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/connectors/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/connectors/en/connector-odbc-usagenotes-apptips-borland.html
BDE, however, does not seem to recognize primary keys, only the index named PRIMARY, although this has not been a problem. With all Borland applications where the Borland Database Engine (BDE) is used, follow these steps to improve compatibility: ...
https://dev.mysql.com/doc/connectors/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/connectors/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/connectors/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.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursordict.html
The keys for each dictionary object are the column names of the MySQL result. Example: cnx = mysql.connector.connect(database='world') cursor = cnx.cursor(dictionary=True) cursor.execute("SELECT * FROM country WHERE Continent = 'Europe'") ...