MySQL DELETE statement is used to delete data from the MySQL table within the database.
By using delete statement, we can delete records on the basis of conditions.
DELETE FROM table_name WHERE (Condition specified);
This table named Students in our database that contains the following records:
Let's check out some examples that demonstrate how it actually works
DELETE FROM Students WHERE ROLL_NO = 6;
The following MySQL statement will Delete the record of student with ROLL_N0 = '6'
After execution, the resulting table will look something like this: