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

This article mainly introduces how to duplicate the data in MYSQL table, hoping to supplement and update some knowledge for everyone, if there are other problems to understand, you can continue to pay attention to my updated article in the industry information.

Copy the original table first

CREATE TABLE New table SELECT * FROM Old table;

Clear the original table

Delete FROM old table;

Copy the deduplicated data back to the new table

INSERT INTO OLD TABLE SELECT [ALL FIELDS] FROM NEW TABLE GROUP BY [ALL FIELDS];

Read the above on MYSQL table data how to heavy, I hope to give you some help in the actual application. Due to the limited space of this article, it is inevitable that there will be deficiencies and needs to be supplemented. If you need more professional answers, you can contact our 24-hour pre-sales service on the official website to help you answer your questions at any time.

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.