Expelling mysql table data

Clear the data deletefrom In the mysql table? Table Name; truncatetable? Table name. The delete statement without the where parameter can delete all contents in the mysql table. You can also use truncatetable to clear all contents in the mysql table. In terms of efficiency, truncate is faster than delete, but does not record mysql logs after truncate is deleted,

Delete from? Table Name; truncate table? Table name. The delete statement without the where parameter can delete all content in the mysql table. You can also use the truncate table to clear all content in the mysql table. In terms of efficiency, truncate is faster than delete, but does not record mysql logs after truncate is deleted,

Clear mysql table data

Delete from? Table Name;

Truncate table? Table Name;

The delete statement without the where parameter can delete all content in the mysql table. You can also use the truncate table to clear all content in the mysql table.

In terms of efficiency, truncate is faster than delete, but after truncate is deleted, mysql logs are not recorded and data cannot be recovered.

The delete operation is a bit like deleting all records in the mysql table one by one until the deletion is complete,

Truncate is equivalent to retaining the structure of the mysql table and re-creating the table. All the statuses are equivalent to new tables.