Delete data from database
This will delete data from the database.
The first query will delete all records where First Name is 'Tom'.
This is done by using the WHERE statement.
| <cfquery name="del_person" datasource="persondb" username="" password=""> DELETE * FROM person WHERE Person_First_Name = 'Tom' </cfquery> |
This query will delete all records in the database.
| <cfquery name="del_person" datasource="persondb" username="" password=""> DELETE * FROM person </cfquery> |
Advertisement
No User Comments.
No User Comments, be the first one to write your comments?
