Help - copy from 1 table to another

[joey3002]

Heres what I want to do..

I want to run a cron job that just copies from 1 table (certain tables) and copies to a 2nd table. I just want it to be an update though.. so i dont end up with dupe data.

like: Table 1
copy: username, realname, address, phone

to table 2:
user, real, address, phone

thanks in advance guys

[johanafm]

First off, add a primary key to both tables so they look like.
table_1
user_id, username, realname, address, phone

table_2:
user_id, user, real, address, phone

INSERT INTO table_1 SELECT * FROM table_2
WHERE table_2.user_id NOT IN
SELECT table_1.user_id FROM table_1