如何删除没有临时表的MySQL表中的所有重复记录

在表上添加 唯一索引 ：

ALTER IGNORE TABLE `TableA`   ADD UNIQUE INDEX (`member_id`, `quiz_num`, `question_num`, `answer_num`);

另一种方法是：

在表中添加主键，然后可以使用以下查询轻松地从表中删除重复项：

DELETe FROM member  WHERe id IN (SELECt *   FROM (SELECt id FROM member         GROUP BY member_id, quiz_num, question_num, answer_num HAVINg (COUNT(*) > 1)       ) AS A );