clear all data from table mysql code example

Example 1: delete all records from table

DELETE FROM table_name;

Example 2: delete all content in table mysql

TRUNCATE tablename

Example 3: mysql delete rows

DELETE FROM table_name
WHERE condition;