Struct ValuesQuery 

pub struct ValuesQuery {
    pub values: Values,
    pub order_by: OrderBy,
    pub limit: Limit,
}

The MySQL VALUES statement (MySQL 8.0.19+).

From https://dev.mysql.com/doc/refman/8.4/en/values.html:

VALUES row_constructor_list [ORDER BY column_designator] [LIMIT number]

row_constructor_list: ROW(value_list) [, ROW(value_list)] ...

Unlike an INSERT’s VALUES list, every row here is spelled with the ROW keyword — that is the grammar, not a flourish — and the result’s columns are named column_0, column_1, …, which is what an ORDER BY refers to.

The rows are the shared Values clause, whose VALUES (…), (…) rendering is the INSERT spelling; this statement writes the ROW form itself. The clause’s query alternative belongs to INSERT and is a recorded build error here.

Fields

values: Values

The rows.

order_by: OrderBy

ORDER BY column_designator.

limit: Limit

LIMIT number.

Implementations

impl ValuesQuery

pub fn new() -> ValuesQuery

A VALUES with no rows yet — which does not build until it has one.

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

Apply more mods to an existing query.

Trait Implementations

impl Clone for ValuesQuery

fn clone(&self) -> ValuesQuery

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for ValuesQuery

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

Formats the value using the given formatter.

impl Default for ValuesQuery

fn default() -> ValuesQuery

Returns the “default value” for a type.

impl Expression for ValuesQuery

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

Append this fragment to w.

impl HasLimit for ValuesQuery

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

The LIMIT clause to modify.

impl HasOrderBy for ValuesQuery

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

The ORDER BY clause to modify.

impl HasValues for ValuesQuery

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

The row source to modify.

impl IntoExpr for ValuesQuery

fn into_expr(self) -> Expr

Perform the conversion.

impl IntoExprList for ValuesQuery

fn into_expr_list(self) -> Vec<Expr>

Perform the conversion.

impl Query for ValuesQuery

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 ValuesQuery

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.