Copy fields

[marketgy]

I'm trying to copy all the email address records that are in the main table called 'email_address' and move them over to a new column I created in the lead table. Now since the keys are unique to each record in the email_address table it throws a primary key error when attempting to do this via mysql query update. I assume I could always just export and start over but I was hoping to avoid this and maybe there is a way to do this via the admin panel some how. The reason I need to do this is when you import records it dedupes by the email field so I'm trying to leave this field intact when I import and only update a newly created field with new email addresses. I need to somehow get all the emails already entered into the email_address table moved over to this new field. Thanks...

[marketgy]

I solved the issue, I did a full export of all fields from the lead table, made necessary modifications, purged existing table and re-imported. Seems to have worked...