Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-wordexcel.html
You use Microsoft Query to build the SQL statement to be executed, selecting the tables, fields, selection criteria and sort order. You can use Microsoft Word and Microsoft Excel to access information from a MySQL database using Connector/ODBC.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-support-version-history.html
It also includes new features, such as enabling server-side prepared statements by default. This section highlights substantial changes per major Connector/ODBC release series, especially useful when updating legacy code. The connector release ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html
In some cases, Access may generate SQL statements that MySQL cannot understand. 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.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-affected-rows.html
Syntax: count = ccnx.affected_rows() Returns the number of rows changed, inserted, or deleted by the most recent UPDATE, INSERT, or DELETE statement.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-consume-result.html
If the statement that was executed returned multiple result sets, this method loops over and consumes all of them. Syntax: ccnx.consume_result() Consumes the stored result set, if there is one, for this MySQL instance, by fetching all rows.
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-free-result.html
If the statement that was executed returned multiple result sets, this method loops over and consumes all of them. Syntax: ccnx.free_result() Frees the stored result set, if there is one, for this MySQL instance.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-insert-id.html
Syntax: insert_id = ccnx.insert_id() Returns the AUTO_INCREMENT value generated by the most recent executed statement, or 0 if there is no such value.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-mysql.html
It is also used to send commands and SQL statements and read results. Syntax: ccnx = _mysql_connector.MySQL(args) The MySQL class is used to open and manage a connection to a MySQL server (referred to elsewhere in this reference as “the MySQL ...
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.