The DELETE Command is used to remove a Record from a Table

Like the UPDATE Command, we want to do this selectively, Mass DELETE ‘s are BAD so we use the WHERE clause

We Decided that Earths Moon does not really belong in this table, so we are going to remove it

DELETE FROM planets WHERE planetID=4;

Woops: Looks like I deleted Planet Earth

Removal Of A Record From A Table