update
fun <T : Table> T.update(where: SqlExpressionBuilder.() -> Op<Boolean>? = null, limit: Int? = null, body: T.(UpdateStatement) -> Unit): Int
Represents the SQL statement that updates rows of a table.
Return
The number of updated rows.
Parameters
where
Condition that determines which rows to update.
limit
Maximum number of rows to update.
Samples
org.jetbrains.exposed.sql.tests.shared.dml.UpdateTests.testUpdate01fun Join.update(where: SqlExpressionBuilder.() -> Op<Boolean>? = null, limit: Int? = null, body: (UpdateStatement) -> Unit): Int
Represents the SQL statement that updates rows of a join relation.
Return
The number of updated rows.
Parameters
where
Condition that determines which rows to update.
limit
Maximum number of rows to update.