[RESOLVED] Copying entire field from table1 to table2

[Tim_Silva]

Hi,

What MySQL command should I use to copy a column. Copy table1.mycolumn1 to table2.mycolumn2. these are not primary keys and table1.column1 has data in all rows while table2.column2 has no data. Both columns are in the same db.

Thanks

Tim

[bradgrafelman]

Is there some sort of relationship between the two tables? If so...

UPDATE table1, table2
SET table2.mycolumn2 = table1.mycolumn1
WHERE table2.id = table1.id

[Tim_Silva]

Thanks a lot. As always, the help was very much appreciated.

Tim