"It's probably too easy to use the DELETE statement, thanks
to the (fairly) consistent syntax of the SQL standard, but I think
it's important to provide you with as much information as
possible -- so here goes:
DELETE FROM table_name WHERE criteria
Now that you've seen it, I want to warn you in loud and
unambiguous language to be EXTREMELY careful when you use it. There
is no undo. And if you forget the WHERE clause or make a mistake in
it, you run the risk of removing the entire table from the
"Just like the UPDATE command, I heartily recommend trying a
SELECT statement using the WHERE clause before you do a DELETE,
just to make sure it works like you expect it to. And you should be
exceptionally careful how you let users interface with the DELETE
SQL Wisdom #2) If users CAN delete data, they WILL
delete it ... accidentally and at the worst possible time."
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.