mysql command to delete data from table code example

Example 1: mysql delete row

DELETE FROM products WHERE product_id=1;

Example 2: delete all content in table mysql

TRUNCATE tablename