Pike v8.1 release 6

Method Mysql.SqlTable()->delete()


Method delete

void delete(string|array where, void|string|array rest)

Description

Deletes records from the table that matches a condition.

Both where and rest may be given as arrays to use bindings or sprintf-style formatting - see handle_argspec for details.

Parameter where

The match condition, on the form of a WHERE expression.

A WHERE clause will always be generated, but you can put e.g. "TRUE" in the match condition to select all records.

Parameter rest

Optional clauses that follows after the WHERE clause in a DELETE, i.e. ORDER BY and/or LIMIT.

See also

remove

FIXME

Add support for joins.