SQL DELETE

Sometimes rather than updating, we wish to get rid of records from the table. To do so, we can use the DELETE FROM command. The syntax for this is

 

 

It is easiest to use an example. Say we currently have a table as below:

Table Store_Information

 

store_nameSalesDate
Los Angeles$1500Jan-05-1999
San Diego$250Jan-07-1999
Los Angeles$300Jan-08-1999
Boston$700Jan-08-1999

 

and we decide not to keep any information on Los Angeles in this table. We type the following SQL:

 

 

 

The resulting table would look like

Table Store_Information

store_nameSalesDate
San Diego$250Jan-07-1999
Boston$700Jan-08-1999