MySQL 8.3.0
Source Code Documentation
Mysqlx::Crud Namespace Reference

Basic CRUD operations. More...

Classes

struct  Collection
 
struct  Column
 
struct  CreateView
 CreateView create view based on indicated Mysqlx::Crud::Find message. More...
 
struct  Delete
 Delete documents/rows from a Collection/Table. More...
 
struct  DropView
 DropView removing existing view. More...
 
struct  Find
 Find Documents/Rows in a Collection/Table. More...
 
struct  Insert
 Insert documents/rows into a collection/table. More...
 
struct  Limit
 
struct  LimitExpr
 LimitExpr, in comparison to Limit, is able to specify that row_count and offset are placeholders. More...
 
struct  ModifyView
 ModifyView modify existing view based on indicated Mysqlx::Crud::Find message. More...
 
struct  Order
 Sort order. More...
 
struct  Projection
 
struct  Update
 Update documents/rows in a collection/table. More...
 
struct  UpdateOperation
 

Enumerations

enum  DataModel { DOCUMENT = 1 , TABLE = 2 }
 DataModel to use for filters, names, ... More...
 
enum  ViewAlgorithm { UNDEFINED = 1 , MERGE = 2 , TEMPTABLE = 3 }
 ViewAlgorithm defines how MySQL Server processes the view. More...
 
enum  ViewSqlSecurity { INVOKER = 1 , DEFINER = 2 }
 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 user who defined the VIEW. More...
 
enum  ViewCheckOption { LOCAL = 1 , CASCADED = 2 }
 ViewCheckOption limits the write operations done on a VIEW (INSERT, UPDATE, DELETE) to rows in which the WHERE clause is TRUE More...
 

Detailed Description

Basic CRUD operations.

The CRUD operations work in a similar fashion as the SQL statements below:

Also operation related to manipulation of views:

Enumeration Type Documentation

◆ DataModel

DataModel to use for filters, names, ...

Enumerator
DOCUMENT 
TABLE 

◆ ViewAlgorithm

ViewAlgorithm defines how MySQL Server processes the view.

Enumerator
UNDEFINED 

MySQL chooses which algorithm to use.

MERGE 

the text of a statement that refers to the view and the view definition are merged

TEMPTABLE 

the view are retrieved into a temporary table

◆ ViewCheckOption

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

Enumerator
LOCAL 

the view WHERE clause is checked, but no underlying views are checked

CASCADED 

the view WHERE clause is checked, then checking recurses to underlying views

◆ ViewSqlSecurity

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 user who defined the VIEW.

Enumerator
INVOKER 

use current user permissions

DEFINER 

use permissions of the user who defined the VIEW