How to Delete in MySQL

To delete rows in a MySQL table, use the DELETE FROM statement:

DELETE FROM products WHERE product_id=1;

The WHERE clause is optional, but you'll usually want it, unless you really want to delete every row from the table.

From MySQL query to chart to Slack in seconds
Get to answers faster, together, with PopSQL and MySQL