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

How to empty the data in the table in the mysql database? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

If you want to replace and update the data when doing data migration, data cleaning or writing web projects, then sometimes you have to empty the table.

There are two commonly used SQL statements for emptying data tables

Delete from table name; truncate table table name

Run the test

I use MySql to test the table with 20000 records. Copy two more copies for testing.

Run the SQL statements of two empty tables respectively

From the results, we can see that both statements can achieve the purpose of clearing the table, and the difference between the two is:

Truncate is more efficient than delete.

Truncate clears the data without logging and cannot recover the data, which is equivalent to retaining the structure of the mysql table and recreating the table. All the states are equivalent to the new table.

After clearing the data, delete records the log, which can recover the data, which is equivalent to deleting all records in the table.

Which method to choose depends on the actual situation. I usually use the delete method. Although the time is slow, it is more safe.

Thank you for reading! After reading the above, do you have a general idea of how to clean up the data in the table in the mysql database? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

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.