Type Alias Subquery

Source

pub type Subquery<'a, ET> = Subquery<'a, ET, DataKind>;

Expand description

Subquery type alias for MySQL
MySQL 的 Subquery 类型别名

A complete subquery that can be appended to other queries. This type represents a fully constructed subquery that can be embedded in WHERE clauses, FROM clauses, or other parts of SQL statements.

可以附加到其他查询的完整子查询。此类型表示可以嵌入到 WHERE 子句、FROM 子句或其他 SQL 语句部分中的完全构造的子查询。

§Type Parameters

ET - The entity type that this subquery operates on
ET - 此子查询操作的实体类型

§Public Methods

table - Create a subquery with the default table name
with_table - Create a subquery with a custom table name
columns - Add the default table to the subquery
filter - Add WHERE condition to the subquery
join - Add JOIN clause to the subquery
group_by - Add GROUP BY clause to the subquery
having - Add HAVING clause to the subquery
append_to - Embed the subquery into a parent query builder

§公共方法

table - 创建带有默认表名的子查询
with_table - 创建带有自定义表名的子查询
columns - 向子查询中添加自定义表
filter - 向子查询中添加 WHERE 条件
join - 向子查询中添加 JOIN 子句
group_by - 向子查询中添加 GROUP BY 子句
having - 向子查询中添加 HAVING 子句
append_to - 将子查询嵌入到父查询构建器中

§Examples

use kitx::mysql::builder::{Subquery, Select};
 
let subquery: Subquery<Article> = Subquery::table()
    .columns(|b| {
        b.push("AVG(views)");
    })
    .filter(|b| {
        b.push("id > ").push_bind(3);
    });

Aliased Type§

pub struct Subquery<'a, ET> { /* private fields */ }

Subquery