DELETE t1 FROM tables_name t1
INNER JOIN
tables_name t2
WHERE
t1.id > t2.id(用于选择保留哪一条数据/保留id最小的) AND t1.name= t2.name(重复的条件);
DELETE t1 FROM tables_name t1
INNER JOIN
tables_name t2
WHERE
t1.id > t2.id(用于选择保留哪一条数据/保留id最小的) AND t1.name= t2.name(重复的条件);