|
That multiple fields bit isn't super clear.. but if you want to combine data in several columns of one table into a single unique column create a new table with one column that has unique index on it. Then for each of the columns in the old table:
insert ignore into newtable (newcolumn) select oldcolumn1 from oldtable;
insert ignore into newtable (newcolumn) select oldcolumn2 from oldtable;
If you just want to keep all unique rows then create new table with the same column structure, create a unique index across all columns, then:
insert ignore into newtable select * from oldtable
__________________
--
react
|