drop all rows in a table mysql code example

Example 1: delete all content in table mysql

TRUNCATE tablename

Example 2: mysql delete rows

DELETE FROM table_name
WHERE condition;