DELETE command removes one or more existing rows from a table.
DELETE FROM table WHERE condition;
Note: If the
WHERE clause is excluded, all rows in the
table will be deleted.
The first example assumes there is a
students table and all the rows where the student has a
not_current status are deleted:
DELETE FROM studentsWHERE enrolled_status = 'not_current';
The next example is more destructive. The entire
students table will be deleted due to there being no
DELETE FROM students;