# 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.

#### Parameters

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.

#### Inheritors

ReplaceSelectStatement

## Constructors

InsertSelectStatement
Link copied to clipboard
constructor(columns: List<Column<*>>, selectQuery: AbstractQuery<*>, isIgnore: Boolean = false)

## Properties

columns
Link copied to clipboard
val columns: List<Column<*>>
isIgnore
Link copied to clipboard
val isIgnore: Boolean
selectQuery
Link copied to clipboard
val selectQuery: AbstractQuery<*>
targets
Link copied to clipboard
val targets: List<Table>
type
Link copied to clipboard
val type: StatementType

## Functions

arguments
Link copied to clipboard
open override fun arguments(): Iterable<Iterable<Pair<IColumnType<*>, Any?>>>

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

prepareSQL
Link copied to clipboard
open override fun prepareSQL(transaction: Transaction, prepared: Boolean = true): String

Returns the string representation of an SQL statement.