MySQL Delete duplicate records

The principle of MySQL deleting duplicate records is:

After placing the column to be compared to group by, remove the minimum value of the primary key, and then delete the row that is not in the primary key of the temporary table

The command line format is as follows

Delete from the users where ID not in (the Select ID from the (select min (id) from the Users group by Name,sex) as TMP);

The columns that need to be compared are name and sex, the ID is removed and the ID is removed from the users table to see if the ID exists in the temporary table, and it is deleted if it does not exist.

MySQL Delete duplicate records