MySQL Clear table data

Delete from table name;

truncatetable 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,

The truncate is equivalent to preserving the structure of the MySQL table and recreating the table, all of which are equivalent to the new table.

2013-09-02

From the Baidu Space migration

MySQL Clear table data