MergeAction in sqlparser::ast

MergeAction in sqlparser::ast - Rust

pub enum MergeAction {
    Insert(MergeInsertExpr),
    Update(MergeUpdateExpr),
    Delete {
        delete_token: AttachedToken,
    },
}

Expand description

Underlying statement of a WHEN clause within a MERGE Statement

Example

INSERT (product, quantity) VALUES(product, quantity)

An INSERT clause

Example:

INSERT (product, quantity) VALUES(product, quantity)

An UPDATE clause

Example:

UPDATE SET quantity = T.quantity + S.quantity

A plain DELETE clause

The DELETE token that starts the sub-expression.