Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-document-ids.html
// using a book's unique ISBN as the object ID myColl.add( { _id: "978-1449374020", title: "MySQL Cookbook: Solutions for Database Developers and Administrators" }).execute(); Use find() to fetch the newly inserted book from the collection by its ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-validation.html
This enables you to require that documents have a certain structure before they can be inserted or updated in a collection. Collections can be configured to verify documents against a JSON schema. Schema validation is performed by the server, which ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/creating-a-collection.html
It returns a Collection object that can be used right away to, for example, insert documents into the database. In order to create a new collection call the createCollection() function from a Schema object. # Create a new collection called ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/crud-ebnf-table-crud-functions.html
TableSelectFunction Table.select() and collection.find() use different methods for sorting results. Table.select() follows the SQL language naming and calls the sort method orderBy(). Use the method sort() to sort the results returned by ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/crud-operations-overview.html
Operation Document Relational Create Section 4.3.1, “Collection.add()” Table.insert() Read Section 4.3.2, “Collection.find()” Table.select() Update Section 4.3.3, “Collection.modify()” Table.update() Delete Section 4.3.4, ... CRUD ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/result-set-classes.html
The type of result returned depends on the operation that was executed. The different types of results are outlined in the following table. SqlResult session.sql().execute() Number of rows affected by the operation, auto generated document IDs, last ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/value-expression-strings.html
This is necessary for both modify() and update(), as well as computing values in documents at insertion time. Value expression strings are used to compute a value which can then be assigned to a given field or column. An example use of a value ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-document-ids.html
// using a book's unique ISBN as the object ID myColl.add( { _id: "978-1449374020", title: "MySQL Cookbook: Solutions for Database Developers and Administrators" }).execute(); Use find() to fetch the newly inserted book from the collection by its ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
To evaluate all user defined schemas: mysql> CALL sys.autopilot_index_advisor(NULL); To evaluate selected schemas: mysql> CALL sys.autopilot_index_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('schema1','schema2', ...))); An example of the output ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing.html
Indexes can improve the query performance of SELECT statements, but index management can increase the overhead of DML operations, INSERT, UPDATE, and DELETE. Autopilot Indexing obtains workloads from the statement digest history stored in the ...