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.

Better SQL for the people
Get more done with PopSQL and MySQL