The DELETE statement is used to delete records in the table.
The general syntax is following:
DELETE FROM table_name WHERE filter condition
The DELETE statement does not actually remove the record in the table. What the command does is to set all column of those deleted records to their default values (0 or " "). If the user wants to be able to completely remove the record, he will need to use CREATE DEFAULT TABLE to build the table in the first place.
One of ABC company's member, Shawn Rose, decided to drop out of the membership. ABC company staff would like to delete his record in the Customer table. He can issue such command:
DELETE FROM Customer Where name='Shawn Rose'
The result will be looks like following: