Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-import.html
To define a new DSN for Connector/ODBC instead, click New and follow the instructions in Section 5.3, “Configuring a Connector/ODBC DSN on Windows”; double click the new DSN after it has been created. To import tables from MySQL to Access, ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-source-windows.html
You only need to build Connector/ODBC from source on Windows to modify the source or installation location. If you are unsure whether to install from source, please use the binary installation detailed in Section 4.1, “Installing Connector/ODBC ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-dynamic-cursor.html
On other platforms, you can enable the dynamic cursor by adding 32 to the OPTION value when creating the DSN. Support for the dynamic cursor is provided in Connector/ODBC 3.51, but dynamic cursors are not enabled by default. You can enable this ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-escape-string.html
Syntax: str = ccnx.escape_string(str_to_escape) Uses the mysql_escape_string() C API function to create an SQL string that you can use in an SQL statement. Raises a TypeError exception if the value does not have a Unicode, bytes, or (for Python 2) ...
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-integrityerror.html
The following example shows a duplicate key error raised as IntegrityError: cursor.execute("CREATE TABLE t1 (id int, PRIMARY KEY (id))") try: cursor.execute("INSERT INTO t1 (id) VALUES (1)") cursor.execute("INSERT INTO t1 (id) VALUES (1)") except ...
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-mysqlconnectionpool-add-connection.html
If this argument is missing, the pool creates a new connection and adds it. Syntax: cnxpool.add_connection(cnx = None) This method adds a new or existing MySQLConnection to the pool, or raises a PoolError if the pool is full. Arguments: cnx: The ...
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.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-constructor.html
If omitted, the cursor is created but its execute() method raises an exception.