Mysql处理重复数据

数据表内容：

SELECT * FROM runoob.runoob_tbl;

统计runoob_title重复次数大于1的个数（HAVING子句设置重复数大于1。）：

select count(runoob_title) as repetitions, runoob_title,runoob_author from runoob_tbl group by runoob_title having repetitions>1;

过滤重复runoob_title重复的列：

select runoob_title,runoob_author submisson_data from runoob_tbl group by runoob_title;

删除重复数据：

create table tmp select * from runoob_tbl group by runoob_title;
drop table runoob_tbl;
alter table tmp rename to runoob_tbl;