删除重复记录SQL

--按重复字段进行分组,同时保存到临时表中

CREATE TABLE tmp as select * from paybackdrill_user group by backdrilltime, paybackdrill_id,u_id,state,payAmount order by id;

--修改临时表的结构及约束

ALTER TABLE tmp modify id bigint auto_increment primary key;

ALTER TABLE tmp DEFAULT CHARSET utf8;

--删除原有表

DROP TABLE paybackdrill_user;

--修改临时表的名称为原表的名称

ALTER TABLE tmp RENAME TO paybackdrill_user;