Shulou(Shulou.com)05/31 Report--

What is the difference between delete from table name and truncate table table name? for this question, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Differences between delete from table names and truncate table table names

The details are as follows:

1.delete cannot return the automatic number to the starting value. But truncate can return the value of the automatically growing column to the default seed

2.truncate can only be emptied at once and cannot be deleted conditionally. However, delete can conditionally clear part of the record.

The performance (speed) of 3.truncate emptying data tables is faster than delete.

4.truncate does not log to the system log and does not trigger delete triggers.

The answer to the question about what is the difference between delete from table name and truncate table table name is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

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.