View Single Post
Old 06-27-2008, 01:49 PM  
FightThisPatent
Confirmed User
 
Join Date: Aug 2003
Location: Austin, TX
Posts: 4,090
Quote:
Originally Posted by theking View Post
...scan and remove duplicates?
you create a new table with the same structure, but set the primary key.

write a php or perl script that reads all the data from the "bad" table, and inserts into the "good" table.

any dupes will be rejected by the primary key

very simple process...


Fight the dupes!
__________________

http://www.t3report.com
(where's the traffic?) v5.0 is out! |
http://www.FightThePatent.com
| ICQ 52741957
FightThisPatent is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote