How to delete the repeated records from a table in MySQL?
Use the below MySQL query to delete the repeated records from a table in MySQL:
1 2 | DELETE FROM Admin WHERE id IN(SELECT * FROM(SELECT id FROM Admin GROUP BY name HAVING COUNT(*) > 1) AS A) |
If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.