Title - DELETE SQL statement Tags - sqlstatements
The DELETE FROM statement deletes one or more rows from a table.
This is useful when you want to delete existing records.
Example:
DELETE FROM celebs WHERE twitter_handle IS NULL;
DELETE FROM is a clause the lets you delete rows from a table.
celebs is the name of the table you want to delete rows from.
WHERE is a clause that lets you select which rows you want to delete. In this case, the statement will delete all of the rows where the twitter_handle column IS NULL.
IS NULL is a condition in SLQ that returns true when the value is NULL and false otherwise.