Deleting duplicate MySQL rows as well as a reference

Deleting duplicate MySQL rows as well as a reference

References

Reference NO 1

http://stackoverflow.com/questions/13656954/deleting-duplicate-mysql-rows-as-well-as-a-reference

Reference NO 2

http://stackoverflow.com/questions/13369663/mysql-delete-duplicates-rows-where-possible

Reference NO 3

http://dev.mysql.com/doc/refman/5.0/en/delete.html

Reference NO 4

http://dev.mysql.com/doc/refman/5.5/en/mysql-indexes.html

Reference NO 5

http://mikefenwick.com/blog/insert-into-database-or-return-id-of-duplicate-row-in-mysql/

Reference NO 6

http://dba.stackexchange.com/questions/21314/remove-duplicate-rows-in-mysql-table-that-does-not-contain-primary-key

Reference NO 7

http://www.tutorialspoint.com/mysql/mysql-handling-duplicates.htm

Reference NO 8

http://www.digimantra.com/interview-or-q-a/delete-duplicate-entriesrowsvalues-in-mysql-table-in-one-query/