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