Struct InsertQuery 

pub struct InsertQuery {
    pub hints: Hints,
    pub modifiers: Modifiers,
    pub table: TableRef,
    pub values: Values,
    pub set: Set,
    pub row_alias: RowAlias,
    pub duplicate_key_update: Set,
}

A MySQL INSERT.

From https://dev.mysql.com/doc/refman/8.4/en/insert.html, with the three row sources folded together:

INSERT [hint_comment] [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
    [INTO] tbl_name
    [PARTITION (partition_name [, partition_name] ...)]
    [(col_name [, col_name] ...)]
    { {VALUES | VALUE} (value_list) [, (value_list)] ...
    | SET assignment_list
    | [(col_name [, col_name] ...)] { SELECT ... | TABLE tbl | VALUES row_list } }
    [AS row_alias[(col_alias [, col_alias] ...)]]
    [ON DUPLICATE KEY UPDATE assignment_list]

INTO is written unconditionally even though the grammar makes it optional: the shorter form saves four characters and costs a reader a double-take.

Three row sources, one field each

VALUES, a query, and SET are alternatives. Values holds the first two; set is the third, and it wins when both are present, because a half-and-half rendering is not a statement. With none of them, VALUES () is written — MySQL’s spelling of “every column takes its default”, which PostgreSQL spells DEFAULT VALUES.

Choosing SET also drops the insert column list, because the SET production does not have one: INSERT INTO t (a) SET b = 1 is a syntax error, not a statement with a redundant clause. PARTITION is in both productions and stays.

No WITH

MySQL permits a CTE only immediately before the SELECT of an INSERT … SELECT, never in front of the INSERT (15.2.20). So there is no with field and no insert::with mod; put the WITH on the sub-query given to insert::query.

Fields

hints: Hints

/*+ … */.

modifiers: Modifiers

LOW_PRIORITY / HIGH_PRIORITY / DELAYED, and IGNORE.

table: TableRef

The target: table, partitions, and the insert column list.

values: Values

The rows, or the query to insert the results of.

set: Set

SET a = 1, b = 2, the assignment-list row source.

row_alias: RowAlias

AS row_alias [(cols)].

duplicate_key_update: Set

ON DUPLICATE KEY UPDATE ….

Implementations

impl InsertQuery

pub fn new() -> InsertQuery

An INSERT with nothing set yet.

pub fn apply(&mut self, mods: impl Mod<InsertQuery>)

Apply more mods to an existing query.

Trait Implementations

impl Clone for InsertQuery

fn clone(&self) -> InsertQuery

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for InsertQuery

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for InsertQuery

fn default() -> InsertQuery

Returns the “default value” for a type.

impl Expression for InsertQuery

fn write_sql(&self, w: &mut SqlWriter<'_>)

Append this fragment to w.

impl HasDuplicateKeyUpdate for InsertQuery

fn duplicate_key_update_mut(&mut self) -> &mut Set

The ON DUPLICATE KEY UPDATE assignments.

impl HasHints for InsertQuery

fn hints_mut(&mut self) -> &mut Hints

The hints to add to.

impl HasModifiers for InsertQuery

fn modifiers_mut(&mut self) -> &mut Modifiers

The modifiers to add to.

impl HasRowAlias for InsertQuery

fn row_alias_mut(&mut self) -> &mut RowAlias

The row alias to set.

impl HasSet for InsertQuery

The INSERT … SET row source, not the ON DUPLICATE KEY UPDATE list — see HasDuplicateKeyUpdate.

fn set_mut(&mut self) -> &mut Set

The assignment list to modify.

impl HasTableRef for InsertQuery

fn table_ref_mut(&mut self) -> &mut TableRef

The table reference to modify.

impl HasValues for InsertQuery

fn values_mut(&mut self) -> &mut Values

The row source to modify.

impl IntoExpr for InsertQuery

fn into_expr(self) -> Expr

Perform the conversion.

impl IntoExprList for InsertQuery

fn into_expr_list(self) -> Vec<Expr>

Perform the conversion.

impl Query for InsertQuery

fn query_type(&self) -> QueryType

Which statement this renders.

fn dialect(&self) -> &dyn Dialect

The dialect this query renders itself in.

fn build(&self) -> Result<(String, Vec<Value>), Error>

Render to SQL and arguments, numbering placeholders from 1.

fn build_from(&self, start: usize) -> Result<(String, Vec<Value>), Error>

build with a different first placeholder position, for splicing into a statement that already has arguments — bob’s BuildN.

impl<H, L, M> QueryExtensions<H, L, M> for InsertQuery

fn hooks(&self) -> &[Hook]

Hooks to run before this query executes.

fn loaders(&self) -> &[Loader]

Loaders to run after this query executes, for eagerly loaded relations.

fn mapper_mods(&self) -> &[MapperMod]

Adjustments to the row mapper, for relations loaded in the same query.