how to delete all table data in mysql code example

Example 1: delete all content in table mysql

TRUNCATE tablename

Example 2: mysql delete rows

DELETE FROM table_name
WHERE condition;