We know how to add data to the database. Now we learn how to remove it. Removal is quite simple. The DELETE command can quickly remove any or all rows from a table. The command DELETE FROM friends will delete all rows from the table friends. The query DELETE FROM friends WHERE age = 19 will remove only those rows that have an age column equal to 19.
Here is a good exercise. INSERT a row into the friends table,
use SELECT to verify the row has been properly added, then use DELETE
to remove the row. This combines the things learned in the previous sections.
Figure shows an example.