how to remove rows in mysql code example

Example 1: mysql delete row

DELETE FROM products WHERE product_id=1;

Example 2: delete all content in table mysql

TRUNCATE tablename

Example 3: mysql remove records

DELETE FROM table_name
WHERE condition;