delete a row from table in mysql code example

Example 1: mysql delete row

DELETE FROM products WHERE product_id=1;

Example 2: how to delete a table entry in mysql

DELETE FROM `table_name` [WHERE condition];

Example 3: delete all content in table mysql

TRUNCATE tablename

Example 4: mysql remove records

DELETE FROM table_name
WHERE condition;

Example 5: delete row mysql

DELETE FROM table_name
WHERE condition;Code language: SQL (Structured Query Language) (sql)