SQLDelete

Jump to bottom Edit New page

jazzzz edited this page Dec 13, 2012 · 1 revision

SQL Delete

The SQL Delete command deletes one or more records from the database. The set of records involved are taken by the WHERE clause.

Syntax

DELETE FROM <Class>|cluster:<cluster>|index:<index> [<Condition>*](WHERE) [BY <Fields>* [ASC|DESC](ORDER)*] [<MaxRecords>](LIMIT)

The WHERE clause is common to the other SQL commands.

Examples

Delete all the records with surname equals to 'unknown' ignoring the case:

delete from Profile where surname.toLowerCase() = 'unknown'

To know more about other SQL commands look at SQL commands.