Changes

Updating and Deleting MySQL Data

395 bytes added, 19:00, 4 October 2007
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).