Search Results
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-16.html
For example: table.Select().Where("additionalinfo->$.hobbies = 'Reading'"); (Bug #29347028) Document Store: The performance for statements that are executed repeatedly (two or more times) is improved by using server-side prepared statements for the ... Functionality Added or Changed Bugs Fixed Functionality Added or Changed Document Store: Support was added for the -> operator to be used with JSON document paths in relational ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-26.html
(Bug #32763765) A data table declared using valid database.table syntax within an Entity Framework model could have extra database names in the generated query (for example, database.database.table). Deprecation and Removal Notes Functionality ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-29.html
X DevAPI Notes Functionality Added or Changed Bugs Fixed X DevAPI Notes An exception was raised when using a TableInsertStatement object to insert a string value containing special characters (- / \ % & =). (Bug #100314, Bug #31692694) ...The ...
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/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() ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-connection-control.html
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS implements an INFORMATION_SCHEMA table that exposes more detailed monitoring information for failed connection attempts. The INFORMATION_SCHEMA.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS table, enabled by the ... The connection-control plugin library enables administrators to introduce an increasing delay in server response to connection attempts after a configurable number of consecutive failed ...