update

fun <T : Table> T.update(where: () -> Op<Boolean>, 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.v1.tests.shared.dml.UpdateTests.testUpdate01

---

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

Represents the SQL statement that updates all rows of a table.

Return

The number of updated rows.

Parameters

limit

Maximum number of rows to update.

Samples

org.jetbrains.exposed.v1.tests.shared.dml.UpdateTests.testUpdate01

---

fun Join.update(where: () -> Op<Boolean>, 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.

Samples

org.jetbrains.exposed.v1.tests.shared.dml.UpdateTests.testUpdateWithSingleJoin

---

fun Join.update(limit: Int? = null, body: (UpdateStatement) -> Unit): Int

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

Return

The number of updated rows.

Parameters

limit

Maximum number of rows to update.

Samples

org.jetbrains.exposed.v1.tests.shared.dml.UpdateTests.testUpdateWithSingleJoin

Generated by Dokka © 2026 Copyright