# update

open fun <T : Table> T.update(where: () -> Op<Boolean>? = null, limit: Int? = null, body: T.(UpdateStatement) -> Unit): UpdateStatement

Represents the SQL statement that updates rows of a table.

#### Return

An UpdateStatement that can be executed.

#### Parameters

where

Condition that determines which rows to update. If left `null`, all columns will be updated.

limit

Maximum number of rows to update.

open fun Join.update(where: () -> Op<Boolean>? = null, limit: Int? = null, body: (UpdateStatement) -> Unit): UpdateStatement

Represents the SQL statement that updates rows of a join relation.

#### Return

An UpdateStatement that can be executed.

#### Parameters

where

Condition that determines which rows to update. If left `null`, all columns will be updated.

limit

Maximum number of rows to update.