update
Represents the SQL statement that updates rows of a table.
Return
The number of updated rows.
Parameters
Condition that determines which rows to update.
Maximum number of rows to update.
Samples
org.jetbrains.exposed.sql.tests.shared.dml.UpdateTests.testUpdate01Represents the SQL statement that updates all rows of a table.
Return
The number of updated rows.
Parameters
Maximum number of rows to update.
Samples
org.jetbrains.exposed.sql.tests.shared.dml.UpdateTests.testUpdate01Represents the SQL statement that updates rows of a join relation.
Return
The number of updated rows.
Parameters
Condition that determines which rows to update.
Maximum number of rows to update.
Samples
org.jetbrains.exposed.sql.tests.shared.dml.UpdateTests.testUpdateWithSingleJoinRepresents the SQL statement that updates all rows of a join relation.
Return
The number of updated rows.
Parameters
Maximum number of rows to update.
Samples
org.jetbrains.exposed.sql.tests.shared.dml.UpdateTests.testUpdateWithSingleJoinDeprecated
This `update()` with a nullable `where` parameter will be removed in future releases. Please leave a comment on [YouTrack](https://youtrack.jetbrains.com/issue/EXPOSED-494/Inline-DSL-statement-and-query-functions) with a use-case if a nullable condition cannot be replaced with the new `update()` overloads.
Replace with
update(limit = limit) { body.invoke() }
Deprecated
This `Join.update()` with a nullable `where` parameter will be removed in future releases. Please leave a comment on [YouTrack](https://youtrack.jetbrains.com/issue/EXPOSED-494/Inline-DSL-statement-and-query-functions) with a use-case if a nullable condition cannot be replaced with the new `Join.update()` overloads.
Replace with
update(limit = limit) { body.invoke() }