Skip to main content

values

Function values 

Source
pub fn values<Q: HasValues>(row: impl IntoExprList) -> impl Mod<Q>
Expand description

One row of VALUES. Several calls append several rows.

Applies to a SELECT as well as to an INSERT, because SQLite’s VALUES (…), (…) is a select-core in its own right — the same mod builds the row source of an insert and a standalone VALUES statement.

A cell may not be DEFAULT: unlike PostgreSQL, SQLite has no per-cell default keyword, only the whole-row DEFAULT VALUES that an INSERT with no rows at all produces.