MySQL 8.4.2
Source Code Documentation
Mysqlx::Crud::Insert Struct Reference

Insert documents/rows into a collection/table. More...

Classes

struct  TypedRow
 set of fields to insert as a one row More...
 

Public Attributes

required Collection collection = 1
 collection to insert into More...
 
optional DataModel data_model = 2
 data model that the operations refer to More...
 
repeated Column projection = 3
 name of the columns to insert data into (empty if data_model is DOCUMENT) More...
 
repeated TypedRow row = 4
 set of rows to insert into the collection/table (a single expression with a JSON document literal or an OBJECT expression) More...
 
repeated Mysqlx::Datatypes::Scalar args = 5
 values for parameters used in row expressions More...
 
optional bool upsert = 6 [default = false]
 true if this should be treated as an Upsert (that is, update on duplicate key) More...
 
ClientMessages::Type client_message_id = CRUD_INSERT
 

Detailed Description

Insert documents/rows into a collection/table.

Returns
Mysqlx::Resultset

Member Data Documentation

◆ args

repeated Mysqlx::Datatypes::Scalar Mysqlx::Crud::Insert::args = 5

values for parameters used in row expressions

◆ client_message_id

ClientMessages::Type Mysqlx::Crud::Insert::client_message_id = CRUD_INSERT

◆ collection

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

collection to insert into

◆ data_model

optional DataModel Mysqlx::Crud::Insert::data_model = 2

data model that the operations refer to

◆ projection

repeated Column Mysqlx::Crud::Insert::projection = 3

name of the columns to insert data into (empty if data_model is DOCUMENT)

◆ row

repeated TypedRow Mysqlx::Crud::Insert::row = 4

set of rows to insert into the collection/table (a single expression with a JSON document literal or an OBJECT expression)

◆ upsert

optional bool Mysqlx::Crud::Insert::upsert = 6 [default = false]

true if this should be treated as an Upsert (that is, update on duplicate key)


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