Deleting rows


Deleting rows is very similar to updating rows, only that type of update done to the row is a delete.

Here is the syntax:

DELETE FROM table_name WHERE column1 = value1 AND column2 = value2 ...

All rows which meet the criteria of the DELETE query will be deleted.

Exercise

Add a DELETE statement which deletes Eric from the customers table.


Copyright © learnsqlonline.org. Read our Terms of Use and Privacy Policy