Shulou(Shulou.com)06/01 Report--

There are mainly the following three:

1. The DELETE statement, which is a delete tag, does not really delete the data, so it can be recovered through the tool; the TRUNCATE statement is to empty the data row directly, so it cannot be restored through the tool.

2, DELETE statement, its ibd file will not be reduced; TRUNCATE statement, its ibd file will be reduced.

3. DELETE statement, DELETE 25W data row, need 22.347sec (because you want to add delete tag); TRUNCATE statement, TRUNCATE 55W data row, only 0.1sec.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.