BulkInsertExpression

data class BulkInsertExpression(val table: TableExpression, val assignments: List<List<ColumnAssignmentExpression<*>>>, val updateAssignments: List<ColumnAssignmentExpression<*>> = emptyList(), val isLeafNode: Boolean = false, val extraProperties: Map<String, Any> = emptyMap()) : SqlExpression(source)

Bulk insert expression, represents a bulk insert statement in MySQL.

For example:

insert into table (column1, column2) values (?, ?), (?, ?), (?, ?)...
on duplicate key update ...

Constructors

constructor(table: TableExpression, assignments: List<List<ColumnAssignmentExpression<*>>>, updateAssignments: List<ColumnAssignmentExpression<*>> = emptyList(), isLeafNode: Boolean = false, extraProperties: Map<String, Any> = emptyMap())

column assignments of the bulk insert statement.

open override val isLeafNode: Boolean = false

the table to be inserted.

the updated column assignments while key conflict exists.