Delete data using SQL
The syntax for an SQL statement that deletes records is:DELETE FROM TableName WHERE condition
Example: Delete a record
When deleting a record, you can use the unique AutoNumber field in the database. In our database, it is the column named id. Using this unique identifier ensures that you only delete one record. In the next example, we delete the record where id has the value 24:Remember that there is no "Recycle Bin" when working with databases and PHP. Once you have deleted a record, it is gone and cannot be restored.