mi数据库表中有些重复记录,如何删除?
注:该方法,不太好用,就是说,删不干净,需要多执行几次。
有库表t_keyword,结构如下(命令:desc t_keyword;):
id bigint(20) NO PRI auto_increment
keyword varchar(50) NO
hot int(3) NO 1
isExist char(1) NO 0
createTime datetime NO
1、得到重复记录,仅仅用于展现。
select id from t_keyword group by keyword having count(id)> 1 order by id
2、构造一张临时表,如t_keyword1
Create table t_keyword1 (select id from t_keyword group by keyword having count(id)> 1 order by id )
3、删除主表中重复的记录
delete from t_keyword where id in( select id from t_keyword1)