deleteIgnoreWhere

inline fun <T : Table> T.deleteIgnoreWhere(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, while ignoring any possible errors that occur during the process.

Note: DELETE IGNORE is not supported by all vendors. Please check the documentation.

Return

Count of deleted rows.

Parameters

limit

Maximum number of rows to delete.

op

Condition that determines which rows to delete.


fun <T : Table> T.deleteIgnoreWhere(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

deleteIgnoreWhere(limit) { op.invoke() }