Delete all duplicate rows except for one in MySQL
Delete all duplicate rows except for one in MySql having no primary key. Someone asked me to delete all rows from a table except one entry with a single query. This is not so easy for me :), Anyway after work and research I have found the solution, I am sharing with you How you can… (1 comment)