BulkInsertExpression

data class BulkInsertExpression : SqlExpression (source code)

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

For example:

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

Name	Summary
<init>	`BulkInsertExpression( table: TableExpression, assignments: List<List<ColumnAssignmentExpression<>>>, updateAssignments: List<ColumnAssignmentExpression<>> = emptyList(), isLeafNode: Boolean = false, extraProperties: Map<String, Any> = emptyMap())` Bulk insert expression, represents a bulk insert statement in MySQL.

Name	Summary
assignments	`val assignments: List<List<ColumnAssignmentExpression<*>>>` column assignments of the bulk insert statement.
extraProperties	`val extraProperties: Map<String, Any>` Extra properties of this expression, maybe useful in SqlFormatter to generate some special SQLs.
isLeafNode	`val isLeafNode: Boolean` Check if this expression is a leaf node in expression trees.
table	`val table: TableExpression` the table to be inserted.
updateAssignments	`val updateAssignments: List<ColumnAssignmentExpression<*>>` the updated column assignments while key conflict exists.

Name	Summary
eq	`infix fun <T : Any> T.eq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Equal operator, translated to `=` in SQL.
neq	`infix fun <T : Any> T.neq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Not-equal operator, translated to `<>` in SQL.
notEq	`infix fun <T : Any> T.notEq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Not-equal operator, translated to `<>` in SQL.