Test WHERE Clauses Before Using Them

The SQL UPDATE and DELETE statements take WHERE clauses to restrict the data being updated or deleted. Failing to provide a WHERE clause causes the update or deletion of all rows in a table, and providing an incorrect WHERE clause could cause the updating and deleting of the wrong rows in a table. It is good practice to test WHERE clauses with SELECT statements (to make sure they retrieve the right set of rows) before using them with UPDATE and DELETE. (Applies to: ColdFusion All)

Leave a Reply