1DELETE FROM table_name WHERE condition;
2In this statement: First, specify the table from which you delete data.
3Second, use a condition to specify which rows to delete in the WHERE clause.
4
5for example:
6DELETE FROM customers WHERE id = 1;
1DELETE FROM table_name [WHERE Clause]
2 1. If the WHERE clause is not specified, then all the records will be deleted from the given MySQL table.
3 2. You can specify any condition using the WHERE clause.
4 3. You can delete records in a single table at a time.
5The WHERE clause is very useful when you want to delete selected rows in a table.
6
7ref: https://www.tutorialspoint.com/mysql/mysql-delete-query.htm