What am I doing now?
Database stuff 
Thursday, November 8, 2007, 11:59 AM - General
Posted by Administrator
A quick way to eliminate duplicate records in a table in mySQL


INSERT INTO new_table(field1,field2...) SELECT DISTINCT field1,field2... FROM duplicateTable;

Match up the fields (field1 to field1) in order and you're set!

add comment ( 1 view )   |  0 trackbacks   |  permalink   |   ( 3.1 / 294 )

<<First <Back | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | Next> Last>>