delete

open fun delete(ignore: Boolean, table: Table, where: String?, limit: Int?, transaction: Transaction): String

Returns the SQL command that deletes one or more rows of a table.

Note: The ignore parameter is not supported by all vendors, please check the documentation.

Parameters

ignore

Whether to ignore errors or not.

table

Table to delete rows from.

where

Condition that decides the rows to delete.

limit

Maximum number of rows to delete.

transaction

Transaction where the operation is executed.


open fun delete(ignore: Boolean, targets: Join, targetTables: List<Table>, where: Op<Boolean>?, limit: Int?, transaction: Transaction): String

Returns the SQL command that deletes one or more rows from a table in a join relation.

Note: The ignore and limit parameters are not supported by all vendors; please check the documentation.

Parameters

ignore

Whether to ignore errors or not.

targets

Join to delete rows from.

targetTables

Specific tables in the join to delete rows from.

where

Condition that decides the rows to delete.

limit

Maximum number of rows to delete.

transaction

Transaction where the operation is executed.