my sql delete all from code example

Example 1: delete all records from table

DELETE FROM table_name;

Example 2: delete all content in table mysql

TRUNCATE tablename