Introduction to Programming

DELETE-statement

The data can be deleted by the DELETE-statement:

DELETE FROM table_name WHERE-clause;

Without the WHERE-clause, all the records of the table are deleted. In the case of the person table, we can delete all the records using the delete from person SQL statement. The following statement deletes all the records with first name Jim from the person table:

delete from person where first_name = 'Jim';