查询重复记录
SELECT COUNT(*) as repetitions, user_id, period FROM dk_user_account GROUP BY user_id, period HAVING repetitions > 1;
创建临时表用以记录去除重复记录
CREATE TABLE tmp SELECT * FROM dk_user_account GROUP BY user_id,period;
删除原表
DROP TABLE dk_user_account;
将临时表更名为原表
ALTER TABLE tmp RENAME TO dk_user_account;