deleteWhere
inline fun <T : Table> T.deleteWhere(limit: Int? = null, op: T.(ISqlExpressionBuilder) -> Op<Boolean>): Int
Represents the SQL statement that deletes only rows in a table that match the provided op.
Return
Count of deleted rows.
Parameters
limit
Maximum number of rows to delete.
op
Condition that determines which rows to delete.
Samples
org.jetbrains.exposed.sql.tests.shared.dml.DeleteTests.testDelete01fun <T : Table> T.deleteWhere(limit: Int? = null, offset: Long? = null, op: T.(ISqlExpressionBuilder) -> Op<Boolean>): Int
Deprecated
This `offset` parameter is not being used and will be removed in future releases. Please leave a comment on [YouTrack](https://youtrack.jetbrains.com/issue/EXPOSED-550/DeleteStatement-holds-unused-offset-property) with a use-case if your database supports the OFFSET clause in a DELETE statement.
Replace with
deleteWhere(limit) { op.invoke() }
Content copied to clipboard