how to use for loop in mysql delete code example

Example: mysql delete row

DELETE FROM products WHERE product_id=1;