Copying content of a mysql table

[turbohost]

Hi,

I want to copy the content of a table with lots of duplicate e-mailaddresses into another, new table (which should have only unique e-mail addresses). How can I do this most efficient? The old table and the new table have different columns. There are also some other columns (like Ip address) I want to copy to the new table).

Turbohost

[jatar_k]

you could script it.

Select row from old table
Check for dup data, add new cols
Insert into new table

shouldn't be too tough, dont remove anything until you have checked, rechecked and then made sure that all went well.

[turbohost]

How do I check for duplicate entries?

[jatar_k]

you could SELECT DISTINCT [mysql.com] which would weed out duplicates.

search the linked page for distinct