Accuracer: The First And Only BDE Alternative
Client-Server Single-File Embedded Database for Delphi / C++Builder / Kylix
The DELETE statement is used to delete one or more rows of data from a table.
FROM 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