Struct UpdateQuery 

pub struct UpdateQuery {
    pub with: With,
    pub hints: Hints,
    pub modifiers: Modifiers,
    pub table: TableRef,
    pub extra_tables: Vec<TableRef>,
    pub set: Set,
    pub where_: Where,
    pub order_by: OrderBy,
    pub limit: Limit,
}

A MySQL UPDATE.

From https://dev.mysql.com/doc/refman/8.4/en/update.html, with the single-table and multiple-table forms folded together:

[WITH [RECURSIVE] with_query [, ...]]
UPDATE [hint_comment] [LOW_PRIORITY] [IGNORE] table_references
    SET assignment_list
    [WHERE where_condition]
    [ORDER BY ...]
    [LIMIT row_count]

There is no UPDATE … FROM. MySQL’s target is a table_references, so a join or a comma joins tables that are all updatable, and SET may assign to any of them. That is the one structural difference from PostgreSQL, and it is why this type implements HasTargetTable rather than HasTableRef — update::inner_join(..) lands on the updated table list, because there is nowhere else for it to go.

ORDER BY and LIMIT belong to the single-table form only; MySQL rejects them once more than one table is named. Nothing here prevents it — the shape is legal and the server is what says no.

Fields

with: With

WITH ….

hints: Hints

/*+ … */.

modifiers: Modifiers

LOW_PRIORITY and IGNORE.

table: TableRef

The first table reference, with its joins.

extra_tables: Vec<TableRef>

Further comma-separated table references.

set: Set

SET ….

where_: Where

WHERE ….

order_by: OrderBy

ORDER BY …. Single-table form only.

limit: Limit

LIMIT row_count. Single-table form only, and there is no OFFSET.

Implementations

impl UpdateQuery

pub fn new() -> UpdateQuery

An UPDATE with nothing set yet.

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

Apply more mods to an existing query.

Trait Implementations

impl Clone for UpdateQuery

fn clone(&self) -> UpdateQuery

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for UpdateQuery

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

Formats the value using the given formatter.

impl Default for UpdateQuery

fn default() -> UpdateQuery

Returns the “default value” for a type.

impl Expression for UpdateQuery

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

Append this fragment to w.

impl HasExtraTables for UpdateQuery

fn extra_tables_mut(&mut self) -> &mut Vec<TableRef>

The additional table references to modify.

impl HasHints for UpdateQuery

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

The hints to add to.

impl HasJoins for UpdateQuery

fn joins_mut(&mut self) -> &mut Vec<Join>

The join list to modify.

impl HasLimit for UpdateQuery

fn limit_mut(&mut self) -> &mut Limit

The LIMIT clause to modify.

impl HasModifiers for UpdateQuery

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

The modifiers to add to.

impl HasOrderBy for UpdateQuery

fn order_by_mut(&mut self) -> &mut OrderBy

The ORDER BY clause to modify.

impl HasSet for UpdateQuery

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

The assignment list to modify.

impl HasTargetTable for UpdateQuery

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

The target table to modify.

impl HasWhere for UpdateQuery

fn where_mut(&mut self) -> &mut Where

The WHERE clause to modify.

impl HasWith for UpdateQuery

fn with_mut(&mut self) -> &mut With

The WITH clause to modify.

impl IntoExpr for UpdateQuery

fn into_expr(self) -> Expr

Perform the conversion.

impl IntoExprList for UpdateQuery

fn into_expr_list(self) -> Vec<Expr>

Perform the conversion.

impl Query for UpdateQuery

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 UpdateQuery

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.