Delete and truncate differences in MySQL

The delete and truncate differences are as follows:

One, flexibility: Delete can conditionally delete data, and truncate can only delete all the data of the table;

Delete from Table_test where ...

TRUNCATE TABLE Table_test

Second, efficiency: delete efficiency is less than truncate,delete is a row to delete, TRUNCATE will rebuild the table structure,

Third, transaction: TRUNCATE is a DDL statement that requires drop permissions, so it is implicitly committed and cannot be Rollback;delete is a DML statement and can be rolled back using rollback.

Iv. Trigger: Truncate cannot trigger any delete trigger, and delete can trigger a delete trigger.

Delete and truncate differences in MySQL