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.