mysql syntax to delete all rows in a table code example
Example 1: delete all records from table
DELETE FROM table_name;
Example 2: delete all content in table mysql
TRUNCATE tablename
DELETE FROM table_name;
TRUNCATE tablename