sql:delete

Performs an SQL DELETE statement. This causes a set of rows to be selected from a given table and deleted.

Attributes

connection

expression

The database connection. The value is an expression, which must evaluate to a database connection object as returned by sql:connect.

table

string

The table containing the rows to be deleted. The value must be known statically (it cannot be defined as an attribute value template).

where?

{ expression }

The conditions to be applied (the contents of the WHERE clause of the select statement). If present the value is an attribute value template whose value is a SQL conditional expression. If omitted, all rows in the table are updated.