EasyTable: Single-File Embedded Database,
a BDE replacement for Delphi and C++Builder
The DELETE statement is used to delete one or more rows of data from a table.
FROM [MEMORY] table_reference [PASSWORD 'password_string']
MEMORY option specifies that in-memory table will be created.
The FROM clause specifies the table to use for the DELETE statement. The syntax is as follows:
The WHERE clause specifies filtering conditions for the UPDATE statement. The syntax is as follows:
Use a WHERE clause to update only records that meets specified conditions.
Here is an example
DELETE FROM Members WHERE ID >= 3