MySQL Database Delete duplicate data in table

Data acquisition, due to the early analysis of the structure of the page is not perfect, resulting in a part of the data collected. After perfecting the code, rerun the scrapy, collect some duplicate data, and search the method of deleting duplicate data.

n.b. When you delete duplicate data from a data table, back up the data table first.

Method One

# Keep the record with the smaller primary key ID DELETE  from WHERE >  and = n2.name# Keep the primary key ID larger record DELETE  from WHERE <  and = N2.name

Method Two

Reference Links:

1. Delete all Duplicate Rows except for one in MySQL? [Duplicate]

MySQL Database Delete duplicate data in table