34,333
edits
Changes
→Deleting Database Data
DELETE FROM products WHERE prod_id = 12134;
</pre>
Keep in mind when using the ''DELETE'' statement to remove all rows in a table that only the rows are removed, and that the table itself remains. To delte the table and its contents use the ''DROP TABLE'' SQL statement:
<pre>
DROP TABLE products;
</pre>
Once again, use this statement is caution. Once a table has been deleted it is gone for good (unless you have performed a recent backup).