INSERT INTO
a table, then specify the value of that tuple, and the result of the command will be to insert one new tuple into that table with the specified value.DELETE FROM
a table, WHERE
a certain condition is true, so this condition is similar to the conditions that we see in the select statement. Then every tuple in the table that satisfies the given condition will be deleted.DELETE FROM
command. It similarily operates on a single table, it then evaluates a condition over each tuple of the table, and when the condition is true, it will modify the tuple.