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.


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

Copyright © Read our Terms of Use and Privacy Policy