MySQL Remove duplicate faster than insert IGNORE?

MySQL Remove duplicate faster than insert IGNORE?

References

Reference NO 1

http://stackoverflow.com/questions/13647544/mysql-remove-duplicate-faster-than-insert-ignore

Reference NO 2

http://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update

Reference NO 3

http://www.xaprb.com/blog/2006/02/21/flexible-insert-and-update-in-mysql/

Reference NO 4

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

Reference NO 5

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

Reference NO 6

http://www.cyberciti.biz/faq/howto-removing-eliminating-duplicates-from-a-mysql-table/

Reference NO 7

http://www.mikeperham.com/2012/03/02/deleting-duplicate-rows-in-mysql/

Reference NO 8

#EANF#