How MySQL clears the table: TRUNCATE TABLE name

Empty all content from a MySQL table

Delete from table name ;

TRUNCATE table name ;

The DELETE statement without the Where parameter removes everything from the MySQL table, and you can also empty all the contents of the MySQL table using truncate table. The efficiency of truncate is faster than delete, but the MySQL log is not recorded after Truncate deleted, and data cannot be recovered.

The effect of delete is a bit like removing all records from a MySQL table to the end of a delete, and truncate is equivalent to preserving the structure of the MySQL table, recreating the table, all of which are equivalent to the new table.

How MySQL clears the table: TRUNCATE TABLE name