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:

• Mysqlx::Crud::Insert - INSERT INTO ...
• Mysqlx::Crud::Find - SELECT ... FROM ...
• Mysqlx::Crud::Update - UPDATE ... SET ...
• Mysqlx::Crud::Delete - DELETE FROM ...

Also operation related to manipulation of views:

• Mysqlx::Crud::CreateView - CREATE VIEW ... AS ...
• Mysqlx::Crud::ModifyView - ALTER VIEW ... AS ...
• Mysqlx::Crud::DropView - DROP VIEW ...

Enumeration Type Documentation

DataModel

enum Mysqlx::Crud::DataModel

DataModel to use for filters, names, ...

Enumerator
DOCUMENT
TABLE

ViewAlgorithm

enum Mysqlx::Crud::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

enum Mysqlx::Crud::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

enum Mysqlx::Crud::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