
Contents > Developing ColdFusion MX Applications > Updating Your Database > Deleting data > Deleting multiple records

Deleting multiple records

You can use a SQL condition to delete several records. The following example deletes the records for everyone in the Sales department (which has Dept_ID number 4) from the Employee table:

DELETE FROM Employee
WHERE Dept_ID = 4

To delete all the records from the Employee table, use the following code:

DELETE FROM Employee

Caution: Deleting records from a database is not reversible. Use DELETE statements carefully.


Contents > Developing ColdFusion MX Applications > Updating Your Database > Deleting data > Deleting multiple records

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.