Register now or log in to join your professional community.
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:
SELECT*FROM names; +----+--------+| id | name |+----+--------+|1| google ||2| yahoo ||3| msn ||4| google ||5| google ||6| yahoo |+----+--------+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?
Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.