DELETE FROM products WHERE product_id=1;

DELETE FROM table_name WHERE condition;<br /> In this statement: First, specify the table from which you delete data.<br /> Second, use a condition to specify which rows to delete in the WHERE clause.</p> <p>for example:<br /> DELETE FROM customers WHERE id = 1;

DELETE FROM table_name<br /> WHERE condition;

DELETE FROM table_name [WHERE Clause]<br /> 1. If the WHERE clause is not specified, then all the records will be deleted from the given MySQL table.<br /> 2. You can specify any condition using the WHERE clause.<br /> 3. You can delete records in a single table at a time.<br /> The WHERE clause is very useful when you want to delete selected rows in a table.</p> <p>ref: https://www.tutorialspoint.com/mysql/mysql-delete-query.htm

</p> <p> DELETE FROM table_name<br /> WHERE condition;Code language: SQL (Structured Query Language) (sql)