Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/building-expressions.html
The first is to use strings to formulate the expressions which should be familiar if you have developed code with SQL before. This section explains how to build expressions using X DevAPI. When working with MySQL expressions used in CRUD, ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-remove.html
The Collection.remove() function is for removing documents in a collection, similar to the DELETE statement for an SQL database. It takes a search condition string (SearchConditionStr) as a parameter to specify the documents that should be removed ...
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/crud-ebnf-collection-crud-functions.html
CollectionFindFunction The syntax for this function in EBNF is: CollectionFindFunction ::= '.find(' SearchConditionStr? ')' ( '.fields(' ProjectedDocumentExprStr ')' )? ( '.groupBy(' SearchExprStrList ')' )? ( '.having(' SearchConditionStr ')' )? ( ...
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/devapi-users-introduction.html
Documents are stored in Collections and have their dedicated CRUD operation set. This guide explains how to use the X DevAPI and provides examples of its functionality. The X DevAPI is implemented by MySQL Shell and MySQL Connectors that support X ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/expression-strings.html
// Using a string expression to get all documents that // have the name field starting with 'S' var myDocs = myColl.find('name like :name').bind('name', 'S%').execute(); . Defining string expressions is straightforward as these are easy to read and ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-document-ids.html
This section describes what a document ID is and how to work with it. Every document has a unique identifier called the document ID, which can be thought of as the equivalent of a table's primary key. The document ID value is usually automatically ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-locking.html
The lockShared() and lockExclusive() methods have the following properties, whether they are used with a Collection or a Table. X DevAPI supports MySQL locking through the lockShared() and lockExclusive() methods for the Collection.find() and ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/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. res = mySession.sql('SELECT name, age FROM users').execute() row ...