SQLMemTable: Embedded BDE Alternative
In-Memory SQL Database for Delphi / C++Builder
Introduction
The DELETE statement is used to delete one or more rows of data from a table.
Syntax
DELETE
FROM table_reference [PASSWORD 'password_string']
[WHERE predicates]
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:
FROM table_reference
The WHERE clause specifies filtering conditions for the UPDATE statement. The syntax is as follows:
WHERE predicates
Use a WHERE clause to update only records that meets specified conditions.
Here is an example
DELETE FROM Members WHERE ID >= 3
|