DELETE
The DELETE
command removes one or more existing rows from a table.
Syntax
DELETE FROM table WHERE condition;
Note: If the WHERE
clause is excluded, all rows in the table
will be deleted.
Examples
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 WHERE
clause:
DELETE FROM students;