Struct TableQuery 

pub struct TableQuery {
    pub table: TableRef,
    pub order_by: OrderBy,
    pub limit: Limit,
    pub offset: Offset,
}

The MySQL TABLE statement (MySQL 8.0.19+) — TABLE t is SELECT * FROM t.

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

TABLE table_name [ORDER BY column_name] [LIMIT number [OFFSET number]]

The struct is that line and nothing more: a bare table name — no alias, no index hints, no PARTITION — and the three tail clauses. WHERE does not exist here and does not compile.

Fields

table: TableRef

The table. Grammar takes a bare name only.

order_by: OrderBy

ORDER BY column_name.

limit: Limit

LIMIT number.

offset: Offset

OFFSET number — part of the LIMIT production, as in a SELECT.

Implementations

impl TableQuery

pub fn new() -> TableQuery

A TABLE with no table yet — which does not build until it has one.

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

Apply more mods to an existing query.

Trait Implementations

impl Clone for TableQuery

fn clone(&self) -> TableQuery

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for TableQuery

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

Formats the value using the given formatter.

impl Default for TableQuery

fn default() -> TableQuery

Returns the “default value” for a type.

impl Expression for TableQuery

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

Append this fragment to w.

impl HasLimit for TableQuery

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

The LIMIT clause to modify.

impl HasOffset for TableQuery

fn offset_mut(&mut self) -> &mut Offset

The OFFSET clause to modify.

impl HasOrderBy for TableQuery

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

The ORDER BY clause to modify.

impl HasTableRef for TableQuery

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

The table reference to modify.

impl IntoExpr for TableQuery

fn into_expr(self) -> Expr

Perform the conversion.

impl IntoExprList for TableQuery

fn into_expr_list(self) -> Vec<Expr>

Perform the conversion.

impl Query for TableQuery

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 TableQuery

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.