update
open fun update(target: Table, columnsAndValues: List<Pair<Column<*>, Any?>>, limit: Int?, where: Op<Boolean>?, transaction: Transaction): String
Returns the SQL command that updates one or more rows of a table.
Parameters
target
Table to update values from.
columnsAndValues
Pairs of column to update and values to update with.
limit
Maximum number of rows to update.
where
Condition that decides the rows to update.
transaction
Transaction where the operation is executed.
open fun update(targets: Join, columnsAndValues: List<Pair<Column<*>, Any?>>, limit: Int?, where: Op<Boolean>?, transaction: Transaction): String
Returns the SQL command that updates one or more rows of a join.
Parameters
targets
Join to update values from.
columnsAndValues
Pairs of column to update and values to update with.
limit
Maximum number of rows to update.
where
Condition that decides the rows to update.
transaction
Transaction where the operation is executed.