exposed-core/org.jetbrains.exposed.v1.core.statements/IStatementBuilder/insert

insert

open fun <T : Table> T.insert(body: T.(InsertStatement<Number>) -> Unit): InsertStatement<Number>

Represents the SQL statement that inserts a new row into a table.

Return

Am InsertStatement that can be executed.

open fun <T : Table> T.insert(selectQuery: AbstractQuery<*>, columns: List<Column<*>>? = null): InsertSelectStatement

Represents the SQL statement that uses data retrieved from a selectQuery to insert new rows into a table.

Return

An InsertSelectStatement that can be executed.

Parameters

selectQuery

Source SELECT query that provides the values to insert.

columns

Columns to insert the values into. This defaults to all columns in the table that are not auto-increment columns without a valid sequence to generate new values.