pub struct Insert {Show 21 fields
pub insert_token: AttachedToken,
pub optimizer_hint: Option<OptimizerHint>,
pub or: Option<SqliteOnConflict>,
pub ignore: bool,
pub into: bool,
pub table: TableObject,
pub table_alias: Option<Ident>,
pub columns: Vec<Ident>,
pub overwrite: bool,
pub source: Option<Box<Query>>,
pub assignments: Vec<Assignment>,
pub partitioned: Option<Vec<Expr>>,
pub after_columns: Vec<Ident>,
pub has_table_keyword: bool,
pub on: Option<OnInsert>,
pub returning: Option<Vec<SelectItem>>,
pub replace_into: bool,
pub priority: Option<MysqlInsertPriority>,
pub insert_alias: Option<InsertAliases>,
pub settings: Option<Vec<Setting>>,
pub format_clause: Option<InputFormatClause>,
}Expand description
INSERT statement.
Token for the INSERT keyword (or its substitutes)
Only for Sqlite
Only for mysql
INTO - optional keyword
TABLE
table_name as foo (for PostgreSQL)
§columns: Vec<Ident>COLUMNS
Overwrite (Hive)
A SQL query that specifies what to insert
partitioned insert (Hive)
§after_columns: Vec<Ident>Columns defined after PARTITION
whether the insert has the table keyword (Hive)
ON INSERT
RETURNING
Only for mysql
Only for mysql
Only for mysql
Settings used for ClickHouse.
ClickHouse syntax: INSERT INTO tbl SETTINGS format_template_resultset = '/some/path/resultset.format'
Format for INSERT statement when not using standard SQL format. Can be e.g. CSV,
JSON, JSONAsString, LineAsString and more.
ClickHouse syntax: INSERT INTO tbl FORMAT JSONEachRow {"foo": 1, "bar": 2}, {"foo": 3}