MYSQL TRUNCATE TABLE

Get ready:

To say that truncate table is going to have to talk about the delete all two of them can be used to delete data rows from the table! On the face of it, delete deleted slowly, TRUNCATE TABLE

Faster,

Delete:

It is an honest line of deleted data, write logs, and the data it deletes can be recovered through the log.

Trunate table:

It does not do this, it simply marks the data page as an empty page (there is no data row), so the log is much smaller.

Then

It is also not a ' silver bullet ' the data deleted by it is unlikely to be recovered through the log because it only notes which pages it has flagged.

This information is not sufficient to support recovery of the table's data rows. It is only possible to restore the previous data in a way that restores the database.

MYSQL TRUNCATE TABLE