How to delete duplicate entries from mysql table ?

Hi,

Add primary key in your table then you can easily remove duplicate entry.

Example:-

DELETE FROM master_table  WHERE id IN (SELECT * FROM (SELECT id FROM master_table GROUP BY master_id, master_quiz, master_question, master_ans HAVING (COUNT(*) >1) ) AS A);

Hope this help.

we insert auto increment on id column then run following command:

delete * from table_name where id > min(id) group by(column1,column2...collumnN) excluding column id

For example, with the following data:

I would use SELECT DISTINCT name FROM names; if it were a SELECT query. How would I do this with DELETE to only remove duplicates and keep just one record of each?