InsertSelectStatement

open class InsertSelectStatement(val columns: List<Column<*>>, val selectQuery: AbstractQuery<*>, val isIgnore: Boolean = false) : Statement<Int>

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

columns

Columns to insert the values into.

selectQuery

Source SELECT query that provides the values to insert.

isIgnore

Whether to ignore errors or not. Note isIgnore is not supported by all vendors. Please check the documentation.

Constructors

constructor(columns: List<Column<*>>, selectQuery: AbstractQuery<*>, isIgnore: Boolean = false)

Returns all mappings of columns and expression types to their values needed to prepare an SQL statement.

open override fun prepareSQL(transaction: Transaction, prepared: Boolean = true): String

Returns the string representation of an SQL statement.