db9010 / com.jovial.db9010 / Database / deleteFrom

deleteFrom

fun deleteFrom(table: Table): Builder

Run a DELETE FROM statement for the given table. See DeleteStatement.Builder for setting additional arguments and parameters. The statement is run after the code body sent to DeleteStatement.Builder.run completes.

Usage example:

    val param = Parameter(Types.sqlString)
    val deleted = db.deleteFrom(Users) + "WHERE " +
            Users.name + " LIKE " + param run {  d ->
        d[param] = "%thing"
    }
    println("$deleted rows deleted.")