Deleting Data in SQL
The SQL ‘delete’ statement can be used for removing a record or records from a database table, which looks as follows.
DELETE FROM table_name WHERE where_condition
DELETE FROM person WHERE id = 3;
The contents of the ‘person‘ table now looks like this.
As with the ‘update‘ statement, multiple records can be deleted at once, if, for example, the ‘where’ condition specified ‘lastname’ to be equal to ‘Smith’, then two records would be deleted.