delete query in status wise in mysql code example

Example: mysql delete row

DELETE FROM products WHERE product_id=1;