Search Results
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/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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-masking-deindentification-functions.html
The following table shows data masking and de-identification functions supported by MySQL HeatWave.
https://dev.mysql.com/doc/heatwave/en/mys-hw-encryption-compression-functions.html
Table 5.6 Encryption and Compression Functions Name Description COMPRESS() Return the result as a binary string. What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for ...Note Deprecated as of MySQL 9.4.0 and scheduled for removal in a future ...