collection.

column definition.

Delete documents/rows from a Collection/Table :param collection: collection to change :param data_model: datamodel that the operations refer to :param criteria: filter expression to match rows that the operations will apply on :param args: values for parameters used in filter expression :param limit: limits the number of rows to match :param order: specifies order of matched rows :Returns: :protobuf:msg:`Mysqlx.Resultset::`.

Find Documents/Rows in a Collection/Table .

Insert documents/rows into a collection/table :param collection: collection to insert into :param data_model: datamodel that the operations refer to :param projection: name of the columns to insert data into (empty if data_model is DOCUMENT) :param row: set of rows to insert into the collection/table (a single expression with a JSON document literal or an OBJECT expression) :param args: values for parameters used in row expressions :param upsert: true if this should be treated as an Upsert (that is, update on duplicate key) :Returns: :protobuf:msg:`Mysqlx.Resultset::`.

limit :param row_count: maximum rows to filter :param offset: maximum rows to skip before applying the row_count.

sort order.

a projection :param source: the expression identifying an element from the source data which can include a column identifier or any expression :param alias: optional alias.

Update documents/rows in a collection/table :param collection: collection to change :param data_model: datamodel that the operations refer to :param criteria: filter expression to match rows that the operations will apply on :param args: values for parameters used in filter expression :param limit: limits the number of rows to match :param order: specifies order of matched rows :param operation: list of operations to be applied.

update operations :param source: specification of the value to be updated if data_model is TABLE, a column name may be specified and also a document path, if the column has type JSON if data_model is DOCUMENT, only document paths are allowed in both cases, schema and table must be not set :param operation: the type of operation to be performed :param value: an expression to be computed as the new value for the operation.

DataModel to use for filters, names, ...

ViewAlgorithm defines how MySQL Server processes the view.

ViewCheckOption limits the write operations done on a `VIEW` (`INSERT`, `UPDATE`, `DELETE`) to rows in which the `WHERE` clause is `TRUE`.

ViewSqlSecurity defines the security context in which the view is going to be executed, this means that VIEW can be executed with current user permissions or with permissions of the uses who defined the VIEW.