Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/creating-documents.html
Once a collection has been created, it can store JSON documents. You store documents by passing a JSON data structure to the Collection.add() function. Some languages have direct support for JSON data, others have an equivalent syntax to represent ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/method-chaining.html
X DevAPI supports a number of modern practices to make working with CRUD operations easier and to fit naturally into modern development environments. This section explains how to use method chaining instead of working with SQL strings of JSON ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/transaction-handling.html
Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none. It is possible to roll back a transaction as long as it has not been committed. Transactions can be ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/understanding-automatic-document-ids.html
This sections describes in detail how document IDs are generated and how to interpret them. X DevAPI relies on server-based document ID generation, which results in sequentially increasing document IDs across all clients. InnoDB uses the document ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-add.html
The Collection.add() function is for storing documents in a collection, similar to the INSERT statement for an SQL database. It takes a single document or a list of documents as its argument, and is executed by the execute() function. The ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collections-as-relational-tables.html
Applications that seek to store standard SQL columns with Documents can cast a collection to a table. In this case a collection can be fetched as a Table object with the Schema.getCollectionAsTable() function. From that moment on it is treated as a ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/creating-a-collection.html
In order to create a new collection call the createCollection() function from a Schema object. It returns a Collection object that can be used right away to, for example, insert documents into the database. # Create a new collection called ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/creating-documents.html
Once a collection has been created, it can store JSON documents. You store documents by passing a JSON data structure to the Collection.add() function. Some languages have direct support for JSON data, others have an equivalent syntax to represent ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/method-chaining.html
X DevAPI supports a number of modern practices to make working with CRUD operations easier and to fit naturally into modern development environments. This section explains how to use method chaining instead of working with SQL strings of JSON ...