Deleting specific data from table
We have a
students table below. Let’s say we want to delete the record rows for all the students who have
SQL provides a
DELETE FROM statement, which can be used to make the above change.
DELETE FROM statement can be broken down in two parts.
The first part is
DELETE FROM followed by the name of the table records are to be deleted from.
The second part is simply a filter, a
WHERE clause with one or more conditions to fulfil for the records to be deleted.