Data Manipulation Language (DML)
Deleting Data from the Database
Let’s look at that first. The syntax for deleting data from the database in MySQL is
A simple implementation of the delete statement would be
As you can see from the above, example: this method removes all data present in the table, leaving behind the table and fields.
A slightly more advanced use of the DELETE clause is as follows
The above example removes all data pertaining to the student whose student id is 101.