Insert Multiple with Where Clause

[siamiam]

I'm using mySQL 5.5.9 and I'm attempting to insert data from one table into another.

 

I have two tables, they both contain a column named 'chargify_id'.

 

I need to copy the chargify_id from table1 into table2 for each entry where the user IDs match (user_id and ID)

 

INSERT INTO table2 (chargify_id)
SELECT chargify_id
FROM table1
WHERE table1.user_id = table2.ID

 

I feel like I'm close, but perhaps not.

 

 

[mikosiko]

you need an UPDATE with JOIN..... no INSERT

 

http://dev.mysql.com/doc/refman/5.0/en/update.html

[siamiam]

I fixed it, thanks for your assistance mikosiko. You're awesome!