Changes

Updating and Deleting MySQL Data

2 bytes added, 18:53, 4 October 2007
Delete Database Data
</pre>
== Delete Deleting Database Data ==
Either all rows, or only specific rows in a table can be deleted using the SQL ''DELETE'' statement. Once again, this statement can, and indeed should, be used in conjunction with the ''WHERE'' clause. Omission of the ''WHERE'' keyword will result in all rows in a table being deleted. In fact, it is often even recommended that the criteria to be used for the ''WHERE'' filter first be tested with a ''SELECT'' statement to ensure it does exactly what you intended.