The DELETE statement should only be used by the DBA when designing or working with new content. This is because the statement is used to remove rows from the database. It is possible that simply removing rows from the database can cause the table to become corrupted. There are better solutions in the design of the database however there are cases that removal of old information is important. The statement can be used after an archive has been done. This allows the DBA to free up database space for old or unused information that is not required to be quickly accessed. The syntax for the DELETE statement is fairly simple compared to the other statements. This is because; it removes whole rows and does not affect individual fields. The following is the standard syntax.
DELETE FROM table1
WHERE field1 = value1