Another tutorial i found on Google, it shows you how to delete duplicate rows of data on your SQL. And after i test it, its really work. Try it!

Link-Back: http://mediakey.dk/~cc/mysql-remove-duplicate-entries/

mysql > ALTER IGNORE TABLE tablename ADD UNIQUE INDEX(value1, value2);

tablename = your own table name
value1, value2 = your own value

Good luck!

Related posts:

  1. HOW-TO: Convert IP Address To SQL Integer
  2. HOW-TO: Send Twitpic Menerusi E-Mail
  3. Menggantikan ShareThis Dengan SexyBookmarks
  4. VideoPress Untuk Self-Hosted WordPress
  5. PayPal Now Works With Malaysia Banks

Tags: ,



Comments are closed.