Search Results
https://dev.mysql.com/doc/relnotes/connector-odbc/en/news-8-0-28.html
(WL #14817) Functionality Added or Changed Connector/ODBC can now establish connections using Multi-Factor Authentication (MFA), such that up to three passwords can be specified. (WL #14657) Bugs Fixed Microsoft Access could unexpectedly halt when ... Deprecation and Removal Notes Functionality Added or Changed Bugs Fixed Deprecation and Removal Notes The TLSv1 and TLSv1.1 connection protocols were previously deprecated in Connector/ODBC 8.0.26 and support for them is removed starting with this ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-12.html
Added properties: schema_name, table_name, table_label, column_name, column_label, type, length, fractional_digits, collation_name, character_set_name. The solution is to repair the Microsoft Visual C++ 2017 Redistributable via the Windows Control ... Deprecation and Removal Notes Installation Notes Functionality Added or Changed Bugs Fixed Deprecation and Removal Notes Deprecated the Row.get_string() method in favor of ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-innodbrowlockwaiters-category.html
Lists the Sys Schema InnoDB Row Lock Waits metrics and provides a brief description of each.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-performance-pages.html
The Performance dashboards are available from the Performance sub-menu of the MySQL Database menu. Graph regions also contain links to week and month overviews of the collected data. Click the appropriate link to display the week or month graph.
https://dev.mysql.com/doc/x-devapi-userguide/en/collection-modify.html
A JSON document (for example, set("Greeting", mysqlx.expr("{'season':'winter', 'phrase': 'Happy Holiday'}")) Note set("$", mysqlx.expr("json_document") replaces all documents matched by modify() with the supplied json_document, except for the ...
https://dev.mysql.com/doc/x-devapi-userguide/en/crud-ebnf-schema-objects-and-functions.html
Schema The syntax for this function shown in EBNF is: Schema ::= '.getName()' | '.existsInDatabase()' | '.getSession()' | '.getCollection(' StringLiteral ')' | '.getCollections()' | '.getCollectionAsTable(' StringLiteral ')' | '.dropCollection(' ...
https://dev.mysql.com/doc/x-devapi-userguide/en/method-chaining.html
The example assumes that the test schema exists and an employee table exists. MySQL Shell JavaScript Code // New method chaining used for executing an SQL SELECT statement // Recommended way for executing queries var employees = ... X DevAPI ...
https://dev.mysql.com/doc/x-devapi-userguide/en/understanding-automatic-document-ids.html
In a multi-primary Group Replication or InnoDB Cluster environment, the generated _id values of a table are unique across instances to avoid primary key conflicts and minimize transaction certification. This document ID format ensures that: The ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-auto-increment-values.html
X DevAPI provides the getAutoIncrementValue() method to return the first AUTO_INCREMENT column value that was successfully inserted by the operation, taken from the return value of table.insert(). In the following example it is assumed that the ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-locking.html
X DevAPI supports MySQL locking through the lockShared() and lockExclusive() methods for the Collection.find() and Table.select() methods. This section describes how to use the lockShared() and lockExclusive() methods for both the Collection.find() ...This enables you to control row locking to ensure safe, transactional document updates on collections and to avoid concurrency problems, for example when using the modify() ...