Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/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-shell-js/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-shell-js/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/x-devapi-userguide-shell-python/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-shell-python/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-shell-python/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-shell-python/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-shell-python/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/heatwave/en/mys-hw-arithmetic-operators.html
All arithmetic operators are supported with variable-length encoded string columns, see Section 5.8.1.4, “Encoding String Columns”.
https://dev.mysql.com/doc/heatwave/en/mys-hw-comparison-functions-operators.html
Table 5.3 Comparison Functions and Operators Name VARLEN Support Description BETWEEN ... What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for OLAP and OLTP Monitor ...