mysql语法如何筛选出重复数据并删除

如何利用mysql语法把数据库中的重复数据筛选出​并删除？下面web建站小编给大家详细介绍一下具体方法！

利用select + count​筛选出重复数据

select * from wp_user where name in (select name from wp_user group by name having count(name) > 1)

利用delete + count​删除重复数据

delete from wp_user where name in (select name from wp_user group by name having count(name) > 1)