-
先看看表中数据
select * from stu_test;
-
可以先查一下需要删除的重复数据
SELECT
id,sname, COUNT(sname)
FROM
stu_test
GROUP BY
sname
HAVING
COUNT(sname) > 1;
3. 然后把重复的数据删除
DELETE t1 FROM stu_test t1
INNER JOIN
stu_test t2
WHERE
t1.id < t2.id AND t1.sname = t2.sname;
删除后的结果:
总结:
根据一个字段分组可以查出重复的条数;
根据字段相等进行删减;