I have these two tables:
user_profile: user_profile_id_int int primary key user_profile_id varchar user_activity: user_profile_id_int int key user_profile_id varchar
both fields in user_profile are ok but I don't have the user_profile_id_int from user_activity and I want to update it using the map I have in user_profile. I wrote a query like this:
update user_activity a set user_profile_id_int = (select user_profile_id_int from user_profile b where a.user_profile_id = b.user_profile_id);
It was running on a really strong server for 1 day and I stopped it. But to record has been updated.
So 2 questions here:
- Is there a better and faster way to do this?
- Is this way ok?