This sample illustrates use of DELETE keyword.
This SQL script contains six queries.
First one deletes table named "developers".
The second creates this table with 3 fields.
Queries 3 and 4 insert some data into the table.
The next query deletes all strings in the table that have 'Bob' as value of "name" field.
The sixth query retrieves all rows from this table.
createtable developers (id AutoInc, code Integer, name varchar(20));
insertinto developers (code, name) values (5, 'Bob');
insertinto developers (code, name) values (7, 'Jeck');
deletefrom developers where name='Bob';
select * from developers orderby name desc, code, id