CreateView create view based on indicated Mysqlx::Crud::Find message. More...

Public Attributes
required Collection	collection = 1
	name of the VIEW object, which should be created More...

optional string	definer = 2
	user name of the definer, if the value isn't set then the definer is current user More...

optional ViewAlgorithm	algorithm = 3 [default = UNDEFINED]
	defines how MySQL Server processes the view More...

optional ViewSqlSecurity	security = 4 [default = DEFINER]
	defines the security context in which the view is going be executed More...

optional ViewCheckOption	check = 5
	limits the write operations done on a VIEW More...

repeated string	column = 6
	defines the list of aliases for column names specified in `stmt` More...

required Find	stmt = 7
	Mysqlx::Crud::Find message from which the SELECT statement is going to be build. More...

optional bool	replace_existing = 8 [default = false]
	if true then suppress error when created view already exists; just replace it More...

ClientMessages::Type	client_message_id = CRUD_CREATE_VIEW

Detailed Description

CreateView create view based on indicated Mysqlx::Crud::Find message.

Member Data Documentation

optional ViewAlgorithm Mysqlx::Crud::CreateView::algorithm = 3 [default = UNDEFINED]

defines how MySQL Server processes the view

optional ViewCheckOption Mysqlx::Crud::CreateView::check = 5

limits the write operations done on a VIEW

ClientMessages::Type Mysqlx::Crud::CreateView::client_message_id = CRUD_CREATE_VIEW

required Collection Mysqlx::Crud::CreateView::collection = 1

name of the VIEW object, which should be created

repeated string Mysqlx::Crud::CreateView::column = 6

defines the list of aliases for column names specified in stmt

optional string Mysqlx::Crud::CreateView::definer = 2

user name of the definer, if the value isn't set then the definer is current user

optional bool Mysqlx::Crud::CreateView::replace_existing = 8 [default = false]

if true then suppress error when created view already exists; just replace it

optional ViewSqlSecurity Mysqlx::Crud::CreateView::security = 4 [default = DEFINER]

defines the security context in which the view is going be executed

required Find Mysqlx::Crud::CreateView::stmt = 7

Mysqlx::Crud::Find message from which the SELECT statement is going to be build.

The documentation for this struct was generated from the following file: