The DELETE
statement removes one or more records from a table. You almost always want a WHERE
clause — trust me.
DELETE FROM
— Specifies the table you want to delete from.WHERE
— Filters which records to delete. Without it, *everything gets wiped*.' '
.;
.WHERE
deletes every row in the table. Always double-check your query before running it.