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

Action DELETE

Delete is a data manipulation language, which can delete the records specified by the where statement in the table, retain the table structure, and do not release storage space.

TRUNCATE

Truncate is a data definition language, emptying the table is equivalent to deleting all the data in the table, preserving the table structure, and freeing up storage space.

DROP

Drop is a data definition language. When deleting, it clears all records in the table and deletes the table structure, freeing up storage space.

Value line efficiency

Drop > truncate > delete

Transaction DELETE

You can use rollback for transaction rollback before the transaction is committed.

TRUNCATE

Implicitly commit transactions and cannot use rollback for transaction rollback.

DROP

Implicitly commit transactions and cannot use rollback for transaction rollback.

references

Https://xiaozhuanlan.com/topic/6375814029

Https://juejin.im/post/5dc03bca6fb9a04aa00147d6

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.