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;
TRUNCATE tablename
DELETE FROM table_name
WHERE condition;