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/devapi-users-crud-operations.html
This section explains how to use the X DevAPI for Create Read, Update, and Delete (CRUD) operations. X DevAPI extends this domain by adding support for CRUD operations that can be run against collections of documents.
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/fetching-all-data-items-at-once.html
The following example assumes that the test schema exists and that the employee table exists in myTable. In addition to the pattern of using fetchOne() explained at Section 9.3, “Working with Data Sets”, which enables applications to consume ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/method-chaining.html
The example assumes that the test schema exists and an employee table exists. // New method chaining used for executing an SQL SELECT statement // Recommended way for executing queries var employees = db.getTable('employee'); var res = ... X DevAPI ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-a-session-object.html
All previous examples used the getSchema() or getDefaultSchema() methods of the Session object, which return a Schema object. Most examples make use of the X DevAPI ability to chain all object constructions, enabling you to get to the Schema object ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-document-ids.html
Every document has a unique identifier called the document ID, which can be thought of as the equivalent of a table's primary key. This section describes what a document ID is and how to work with it. The document ID value is usually automatically ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-sql-result-sets.html
When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to working with results from CRUD operations. var res = mySession.sql('SELECT name, age FROM ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/boolean-expression-strings.html
Boolean expression strings can be used when filtering collections or tables using operations, such as find() and remove(). The following example of a boolean expression string uses find() to search for all documents with a “red” color attribute ...
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 ...